Thread: Syntax Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Syntax Question

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: