LastRow = rows.count 'last row may be different in diferent versions of excel
rows("200:" & LastRow).delete

" wrote:

Is it possible to remove rows beyond 200 from a worksheet. If I can
then the rest of my problem goes away. Have tried quite a few ideas no
luck so far. My idea is a macro that will do this and run it befor I
proceed.