Delete entire rows where there is a blank in column A

Posted to microsoft.public.excel.programming

Chris Hankin[_2_] Chris Hankin[_2_] is offline

external usenet poster

Posts: 8

Delete entire rows where there is a blank in column A

Hello,

Could someone please advise on a macro code that would do the following:

If there is a blank cell in column A, then delete the entire row . I
need this to loop around from A2:A60000.

Any help would be greatly appreciated.

Thanks,

Longbow :-)

Live Long and Prosper :)

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to Delete entire rows by selecting different text in column A	Doug[_5_]	Excel Discussion (Misc queries)	2	November 20th 09 02:03 PM
Easiest way to delete blank cells in column (not entire row)	sramsey	Excel Discussion (Misc queries)	4	February 16th 06 04:28 PM
To Delete the specific rows when blank is found on column A	ddiicc	Excel Programming	3	August 5th 05 05:32 AM
Delete Entire Row If Column C is Blank	John	Excel Programming	5	July 19th 04 10:23 PM
macro to delete entire rows when column A is blank ...a quick macro	vikram	Excel Programming	4	May 3rd 04 08:45 PM

All times are GMT +1. The time now is 02:15 AM.

Menu

About Us