ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Syntax Question (https://www.excelbanter.com/excel-programming/347272-syntax-question.html)

David Godinger

Syntax Question
 
What does this do?

Dim aCell As Range

Please delete "ANTI-SPAM" from email address:

Bob Phillips[_6_]

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:






All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com