Selecting cells in Macros

Posted by Mike Grady on November 05, 2001 11:03 AM

How can I set up a counter to select a cell in order to compare it to another cell, and then select the next cell? I thought it would be something like

range("A" counter).Select

with the counter being just that.

Help would be greatly appreciated.

Posted by faster on November 05, 2001 11:27 AM

looks pretty good, just concantenate it with "&"

Sub x()
Dim counter

For counter = 1 To 5
Range("A" & counter).Select
MsgBox "Current cell " & ActiveCell.Address
'do whatever
Next counter
End Sub

Posted by Mike Grady on November 07, 2001 10:02 AM

Thanks a lot!!!