I need to run a procedure n times, where n is the count of records in Column
A of the current sheet. How do I write the code?

Grateful for any help.

For i = 1 To Application.CountA(Columns(1))
'your macro
Next i

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Snowsride" wrote in message
...
I need to run a procedure n times, where n is the count of records in
Column
A of the current sheet. How do I write the code?

Grateful for any help.