cell references in vba
I hit 'Post' before intended.
Use OFFSET; For example
Range("A1").Offset(5,2).Select will select the cell 5 rows down and 2
columns right ie; C6
In your case it would be
Range("I1").Offset(done,laps).Select
OR may be
Range("I1").Offset(done-1,laps-1).Select
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
Use OFFSET; For example
Range("A1").Offset(5,2).Select will select 5 the cells 5 rows down and 2
columns right.
If this post helps click Yes
---------------
Jacob Skaria
"NDBC" wrote:
I am trying to select a cell I know it is a certain amount of columns to the
right of column "i" (variable called laps) and a set number of rows down
(variable called done).
Effectively i want is .Range("i"+laps & done). What is the correct code for
this.
Thanks
|