sorry in my code I forgot to add a line after the messagebox

activecell.offset(1,0).select

Sorry....

HTH

"Diane Alsing" wrote:

> I have a spreadsheet that will have a varying number of rows of data. I need
> to write a macro that will (for each row of data) run my code until there are
> no more rows of data.
>
> Also, my data rows do not start at the top of the sheet, the rows start at
> row 5 so I guess I will need some type of offset or something like that.
>
> While there's rows of data
>
> - my code here -
>
> End when there's no more data
>
> Any help would be greatly appreciated.