Posted to microsoft.public.excel.programming

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Delete all rows where column A is blank

Do you really need a macro?

Select column A

F5SpecialBlanksOK

EditDeleteEntire Row

Gord Dibben MS Excel MVP

On Thu, 10 Dec 2009 13:59:01 -0800, Jodie
wrote:

I need to write a macro to delete all rows where column A is blank. Can
anyone help me with this please?

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
Delete rows if column looks blank	[email protected]	Excel Programming	4	February 18th 09 07:21 PM
delete the non blank rows depending on Column	Harn88	Excel Programming	1	November 18th 08 08:37 AM
Delete Blank Rows - specify column via dialog	porter444	Excel Programming	1	November 30th 07 04:45 PM
Delete Rows if any cell in Column H is blank but do not Delete Fir	manfareed	Excel Programming	4	September 28th 07 05:20 PM
Delete entire rows where there is a blank in column A	Chris Hankin[_2_]	Excel Programming	7	June 11th 06 09:56 AM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us