specify row number in Offset

[scorpweb]

Hey All,

I have an offset range i am trying to call based on a cell with the value of 60. (this is declared as offset2)

I want the offset to look in Row 60 etc.

I know i can do .offset(-1,0) etc. but is there a way to tell it to just check that row? as oppose to the +1, -1 stuff

thanks

 

[Danerida]

You don't need to use .offset then. Use Cells e.g. Sheet1.Cells(60, ColumnNumber)

 

[scorpweb]

You don't need to use .offset then. Use Cells e.g. Sheet1.Cells(60, ColumnNumber)

:O thanks! will give it a try thanks so much this has been driving me nuts!

 

[scorpweb]

You don't need to use .offset then. Use Cells e.g. Sheet1.Cells(60, ColumnNumber)

omg now i'm doing it this way it's soooo obvious!!

thanks so much! works great