It might help if you showed us your code (at minimum, the part that test the
criteria and "removes" the entire row).

--
Rick (MVP - Excel)


"Jock" wrote in message
...
A worksheet has 1000 formatted rows some of which contain formulae.
A macro will remove entire rows when certain criteria is met and paste to
a
different sheet.
When this happens, the number of formatted rows decreases in number by the
same amount that have been moved.
How can I ensure that I always have 1000 rows regardless of how many rows
are removed?
--
Traa Dy Liooar

Jock