Try this

dim R as integer
for R 1 to 20
with sheets("SheetName").cells(R,1)
function
end with
next

"Himszy" wrote:

I want to create a loop that will repeat on cells A1:A20. I've written the
if function for it I just need help on the loop. Any ideas?

Thanks Michael