since you said:
of a sheet with up to 200
entries in column A starting at row 3

Why wouldn't column A be a sufficient indicator of the lastrow.

Nonetheless, glad you succeeded.

--
Regards,
Tom Ogilvy

"br0ke" wrote in message
...
I had to change to

lastrow = worksheets("Sheet1").usedrange.rows.count

but everthing else worked well. Thanks....