Skipping a set number of rows
 

I just need to be able to grab ever 10th cell in column A and I can't
for the life of me figure out how.

Skipping a set number of rows
 

Do Until ActiveCell.Offset(10,0).Value = ""
' more stuff here
ActiveCell.Offset(10,0).Select
Loop

Something like that should do the trick.

Piers

Skipping a set number of rows
 

grab???
have a look in the help index for MOD

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
I just need to be able to grab ever 10th cell in column A and I can't
for the life of me figure out how.