Posted to microsoft.public.excel.programming

THE_RAMONES THE_RAMONES is offline

external usenet poster

Posts: 24

Delete row if no date exist

I have a macro that combines multiple sheets into one. I want to add to the
macro that once the master file is compiled, delete any row in column "A"
that doesn't have date

Basically

if A1 = 03/28/06 keep row
if A1 = null,text,etc delete row.

Thanks in advanced...

Ramon

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 do I delete a row automatically after each date	delete automatically	Excel Discussion (Misc queries)	11	December 20th 06 08:40 PM
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it.	Tintin92	Excel Programming	3	March 11th 06 06:45 PM
delete sheet if it exist	Art Parra	Excel Programming	2	February 7th 06 04:16 PM
Delete Entire Row - Date	Matt Cromer	Excel Programming	2	August 9th 05 05:15 PM
How2 Delete "Not exist" charts/sheets?	fatfish[_4_]	Excel Programming	4	July 22nd 04 02:17 PM

All times are GMT +1. The time now is 08:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us