What does this do?

Dim aCell As Range

Please delete "ANTI-SPAM" from email address:

It declares a range variable named aCell. You can trhen use that variable to
set to a particular range

Set aCell = Range("A1:A5")

or to look through another range

For Each aCell in Range("A1:A5")
....
Next aCell

--

HTH

RP
(remove nothere from the email address if mailing direct)


"David Godinger" wrote in message
...
What does this do?

Dim aCell As Range

Please delete "ANTI-SPAM" from email address: