Hi. i have seen a couple of examples on how to define range/ cells.
There is a particular one which i am curious about
Range(counter & ":" & counter).Value
counter defines an integer variable.
does the above statement means selecting the entire row, of which counter specifies?
for the e.g. entire row 1 etc.
Also, typical examples shows the defining of range as Range("A1:B3"). The entire range is in quotes. Why is it that for the first example, only the colon is in quotes?
Thank you
Bookmarks