I have two three queries?

FIRST

If I say

Dim rng As range
Dim cell As range
Set rng = range (A1: C:10)

rng.columns(2).select

"and then say"

For Each cell in rng

blah
blah


My question is does rng now just refer to column 2 or does it refer to the
whole range object declared.
I'm new to VBA (have done a little JAVA) and the statement
rng.columns(2).select on its own seems odd.
I would usually expect something more like
rng = rng.columns(2).select but does just rng.columns(2).select basically
just have that affect until some other function is called on the rng object?

SECONDLY

I have a variant which may hold a long.
I know = cont(integer) will work for an integer,
is there an equivalent for a long?


THIRDLY

If from question one, i have a cell (range object) in the for loop and want
to add a comment to the right of that cell by three columns but same row how
do i do it.
I think i probably need the offset function?

Something like

For Each cell in rng

cell = cell.offset(3,0)
cell.addcommment ("comment")

next cell

MANY MANY THANKS
James