Thread: offset question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] idyllicabyss@googlemail.com is offline
external usenet poster
 
Posts: 32
Default offset question

Hmm...
I'm not clear on exactly what you want or which bit isn't working but
here goes.

Range(2,X+1) = v

Row reference then columnn reference. So row 2, Column X + 1.
This should give you range(2,2) throught to range(2,13)
which is columns B to M

rather than
Range(X&2) = v

the "&" character will either add the numbers together or attempt to
concatenate them into a string, I'm not sure without testing.