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.
|