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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vop2311

    Issue in Range and If statement . Please help

    Thanks SkipVought. Truly appreciated. It worked well :)
  2. vop2311

    Issue in Range and If statement . Please help

    ok. My logic is that I want to compute some formula based on condition of some cells range as below. if cell range value of c1 to c25 and b1 to b25 is greater than 0 and then less than 999999 do ( (c10*c8)-(c9*b13)/(C10+B13) ) otherwise display "value should be between 0 to 999999"...
  3. vop2311

    Issue in Range and If statement . Please help

    That is just a comment so please ignore. Someone told me to use like this but i am not sure how would it work as I am new to VBA :(. Please help. Thanks, Vik WorksheetFunction.Sum (Rng1) WorksheetFunction.Sum (Rng2)
  4. vop2311

    Issue in Range and If statement . Please help

    Hi, I am getting "error -13 type mismatch "in this line below from my code "If Rng1.Value >= 0 And Rng2.Value <= 999999 Then" Basically I want to calculate formula only if values are greater than 0 and less than 099999. Any help would be appreciated. Thanks, Vik 'mycal() is function...

Part and Inventory Search

Back
Top