LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default selecting all blanks in multiple columns, then deleting those rows

I have done this in just one column: selecting all the blanks and then using
Selection.EntireRow.Delete. Works fine.

I am now working with a dataset that is formatted just terribly, full of
headers and subtotals, and the best way to clean it up would be to highlight
the entire range (OK), select all the blanks (OK), and delete the rows (not
OK).

I get no error message, but Excel just skips that line of code and leaves
all the blanks highlighted as nice as you please. Just neglects to delete
them.

Is this because they are scattered in all different columns? When I stop the
macro and go to Excel itself, Edit/delete/row wipes out all the proper rows.
Just can't get it done programmatically, and I don't know why.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows or Columns DGoldwasser Excel Discussion (Misc queries) 1 March 18th 09 07:03 PM
Multiple sets of columns into one set of columns no blanks CathyH Excel Discussion (Misc queries) 0 May 22nd 07 09:11 PM
Deleting Rows and columns wx4usa Excel Discussion (Misc queries) 2 May 7th 07 11:56 PM
automatically filter out blanks in multiple columns gmr7 Excel Worksheet Functions 2 June 3rd 05 07:36 PM
Counting rows of blanks across certain columns crossingboston New Users to Excel 1 May 26th 05 05:20 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"