Mike,

All that code is doing is defining three variables, all of range datatype.
In itself, it does nothing, each variable is nothing at that point, but
worksheets ranges can be loaded (set cell = Range("A1")) and then used in
any subsequent processing. AT this point they also have no relationship to
one another.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mike" wrote in message
...
I would like to understand this..lets see if i understand
what it is telling vb to do.

...
Dim cell As Range, rng AS Range
Dim rng1 As Range
...

this is part of the whole code i have but i was thinking
of this part...
Does this mean that it is setting a "cell" as a range in
the whole workbook and when it sees what it is looking
for in that cell then that cell is referred to as rng1
for the moment?
can anyone clarify and tell me if i am close or in the
outfield?

mike