Hi
this code part is just the variable declaration. It tells VBA which
type of variable 'rng' or 'cell' are (you can replace these names with
whatever name you like)
Another example would be:
Dim Str as String
this tells VBA what Str is a string variable. You may take a look at
the following website to learn more about VBA:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Regards
Frank Kabel
Frankfurt, Germany
mike wrote:
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