Delete Rows then Move Up

Posted to microsoft.public.excel.programming

Gordon[_2_] Gordon[_2_] is offline

external usenet poster

Posts: 211

Delete Rows then Move Up

Hi...

I have 3000 records. In column B there are sporadic #N/A values. I need some
nicely packaged code that will delete all rows where a #N/A appears in B, so
that there are no gaps in the rows. Sounds easy but I'm struggling.

Any help would be most appreciated.

Thanks

Gordon...

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
Macro to delete blank rows and move data/info	samoan	Excel Discussion (Misc queries)	3	September 19th 08 04:50 PM
Delete and Move Up	Gordon[_2_]	Excel Programming	4	September 29th 06 04:00 PM
How to delete rows when List toolbar's "delete" isnt highlighted?	Linda	Excel Worksheet Functions	1	May 26th 05 08:39 PM
Button to move row and delete old row	Stacie Fugate[_2_]	Excel Programming	12	January 27th 05 09:25 PM
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below	Annette[_4_]	Excel Programming	2	September 21st 04 02:40 PM

All times are GMT +1. The time now is 06:45 AM.

Menu

About Us