Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. carfreak01

    Modification of Formula - Clarification

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

    Modification of Formula - Clarification

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

    Modification of Formula - Clarification

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

    VBA Variables

    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...
  5. carfreak01

    VBA Variables

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

    VBA Variables

    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?
  7. carfreak01

    VBA Variables

    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.
  8. carfreak01

    VBA Variables

    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.
  9. carfreak01

    air filter vs fuel economy (tricky question?)

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

    air filter vs fuel economy (tricky question?)

    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...
  11. carfreak01

    VBA Variables

    Thank you all for all your help.
  12. carfreak01

    VBA Variables

    ...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.
  13. carfreak01

    VBA Variables

    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.
  14. carfreak01

    VBA Variables

    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...
  15. carfreak01

    Vibration Welding

    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
  16. carfreak01

    Has anyone ever used electric water pump?

    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.
  17. carfreak01

    Has anyone ever used electric water pump?

    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.
  18. carfreak01

    text from a cell to VBA

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

    text from a cell to VBA

    Yes I did, and still nothing happend.
  20. carfreak01

    text from a cell to VBA

    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?

Part and Inventory Search

Back
Top