I need a macro that will find the last row in colA containing data and then
delete the next 100 empty rows.
Thank you if you can help.
Pat