J
John Keith
I need some one to teach me a finer point of specifying range
addresses. I can do the simple stuff but I want to have a range
address that includes a constant and a variable like might be the case
in a loop. I've tried several approaches and I usually get an error
message ("compile error: expected: list separator or )") when I enter
the line. Here's a simple example of what I want to do:
For i = 1 to lastrow
Range("A" & i:"D" & i) = something
Next i
For each row in the loop set cells A, B, C and D to the same value.
Thanks for pushing me further down the learning curve!
John Keith
(e-mail address removed)
addresses. I can do the simple stuff but I want to have a range
address that includes a constant and a variable like might be the case
in a loop. I've tried several approaches and I usually get an error
message ("compile error: expected: list separator or )") when I enter
the line. Here's a simple example of what I want to do:
For i = 1 to lastrow
Range("A" & i:"D" & i) = something
Next i
For each row in the loop set cells A, B, C and D to the same value.
Thanks for pushing me further down the learning curve!
John Keith
(e-mail address removed)
" & i).Select