I am using Excel 97.

I have some code which finds an empty row and then populates cells in the
13th column for the previous 7 rows.
Using activecell.offset(-7,13)

My code debugs when there aren't 7 rows before the empty row!

Can someone assist me with some code which checks to see if there are 7 rows
before the empty row and if not moves to the next sheet.


----
Mark