Search results for query: *

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.

...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 dim as long even if their value range falls in the integer category.

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

You know what, maybe that electric valve can be linked to the TPS sensor to regulate the flowrate and you can put a return line with another electric valve also linked to the TPS sensor that will function as a relief valve. Hahaha, I got carried away, but its an idea. Good luck.

Why not trying to leave the orifice at the maximum diameter for WOT and controll the flowrate with an electic activated valve for idle temperatures and pressures.

Hello Panars, your idea worked. Thank you all for replying and thank you all very much for your help. Jose Luis Walters

Yes I did, and still nothing happend.

I wrote a simple code to make a test and it seems like I have to write in the cells ="FIN" or =123 so that the VB code can read it if I don't use the = it seems that the VB code can't read it. Can anyone help me with this problem?