Cell Reference

[Guest]

how to ensure cell reference created in macro is working correctly under
excel worksheet?

If Col <= 7 Then Range("X1").Select

when the arguement is less than 7, it should go to worksheet cell X1, but
end up in cell Y2. why?

 

[Tom Ogilvy]

if you open a brand new workbook and put in code like

Sub Tester1()
dim col as Long
col = 5
if col <= 7 then Range("X1").Select
End sub

then run it, you should end up in cell X1. If that isn't happening in your
current environment, then it is something besides that line of code
contributing to the problem.

 

[Steve Smallman]

Ok, how are you defining the variable "Col"

Steve