deleted rows still show up in report

K

Keith G Hicks

This is something I've experienced for many years but never really worried
about until now. It's become a problem for some automation I'm doing using
xlt files. If I have data in rows that I want to remove and then I highligth
those rows using the row numbers column and then right click to get the
delete option (not the DELETE key) the rows are gone. But let's say that I
have a header row and 500 rows below that with info in them. I delete the
500 rows. Then I run a preview of the report (where the grid shows). I end
up with blank pages when I preview or print this. I should expect only to
get the header row. How can these rows REALLY be deleted so they are not
ghosts in the sheet? (no pun intended).

Thanks,

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to remove rows? 5
Delete rows in a sequence 9
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Macro to compare rows in 2 files where ID is the same 0
VBA Excel: Move rows which match a certain feature between tabs 3
text in rows in small height 3
Deleting Rows - only deletes content 2
Deleting/removing unused rows in a worksheet 3

Top