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

delete duplicates 0
loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Do not delete row with cell in Column B = 0 4
Exel 2007: Show row over row 2
Delete Rows Based on highlighted Color 7
Visio 2010 - Deleted shape data fields not disappearing 1
Insert/ delete row in protected worksheet 6
Help! Can’t debug macro used to delete duplicate rows 2

Top