Excel macro help needed

[mhudson]

I have to import into Excel a tab-delimited file from another application from which to generate a new spreadsheet on a daily basis. The result is a sheet with numerous rows of unneeded data which have to be manually deleted.

Is there a way to write a macro (or VBA script) which will delete a row if a certain cell within that row is empty? If possible, this would be a tremendous time-saver. Thanks in advance!

 

[xlbo]

Please do a search in the VBA forum - there are many. many. many threads relating to this issue

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244