Recent content by carfreak01

jghrist, you are right, it did work with CELL("address",I9), that is a very useful information, thanks.

I think there is no way to make it change, the only way I could come up with was the same MintJulep sugested.

Just avoid using "" in the I9 part of the formula.

MortenA, in fact, the example I used is the one provided by the help function of the VBA editor. I was searching for some information on the overflow error and since it's a very short and clear example I used it. Tomorrow when I get to my computer I'll post the code I was having problems with...

Thanks IRstuff, now I get it, now I know why. Thank you all for all your helpful information.

IRstuff, I think "melone" explained my doubt in a more clear way. I'm declaring as LONG the variable in which I am going to store a result of an operation, like "melone" said, shouldn't ALU match the dimension of the variable I'm using to save the information?

Now I know that the dimension of the variables have to match the dimension of the result of the operation in which they are involved even if they are in a different category by themselves. But I still don't know why.

And also you can declare it like this: CLng(2000) and it will be declare as long CStr(x) for string....etc. You can check it in the "Members of Conversion" in the VBA editor.

I notice I wrote that the driver's economy will be afected, that's wrong, I'm sorry, only engine performance.

I'm not an expert but this is my opinion on the matter: The mass of air that is flowing thru the air intake system is metered so that the computer can calculate the amount of fuel that has to be injected. So if a dirty filter is used, then less mass of air will flow thru, so less mass of air...

Thank you all for all your help.

IRstuff, you're right, I'm confused, so it doesn't matter if the variables are long enough to be integers, if the result is going to be a long integer, the variables should be declare as long integer, is that correct? like for example: a = 32767 b = 32767 x = a * b a and b should be...

MMmm, that's odd, I'm already declaring x as long, why would the processor expect anything different from what I'm dimensioning? So should the processor expect a long integer result from a long integer variables operation? For example: b = 300000, c = 150000 x=b/c This does not generates an error.

Does anybody know why if I write this code in a command button: Private Sub CommandButton1_Click() Dim x As Long x = 2000 * 365 Worksheets("Sheet1").Range("A1").Value = x End Sub The program detects an Overflow error, But if I type the following code: Private Sub...

Hello everybody, I need information on the process of linear vibration welding, I don't know the process I need to know everything related to it, does anyone knows a good source of info? Any help on this matter would be very much appreciated. José Luis Walters Ochoa