Posted to microsoft.public.excel.programming

DukeDevil

external usenet poster

Posts: 8

Automatically Removing Rows where Cells A:R are Blank

Hello,

I have a whole bunch of data that I keep mooving between sheets.
Sometimes I forget to delete the row once I have moved it. Is there any
sort of VBA code that I can write that recognizes when cells A to R are
BLANK and then automatically deletes the row? Please let me know.

Thank you.

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
Removing blank cells in rows of data	Andy in Edinburgh[_2_]	Excel Worksheet Functions	8	September 8th 08 06:12 PM
Removing Blank Rows ?	Robert11	New Users to Excel	3	November 13th 06 03:07 PM
Removing blank rows	Bob	Excel Programming	10	June 21st 06 12:49 AM
Removing blank rows	Carlton Patterson	Excel Programming	2	July 17th 05 12:02 PM
Copying and pasting a worksheet to a blank and removing blank rows	Bob Reynolds[_3_]	Excel Programming	0	June 24th 04 02:55 PM

All times are GMT +1. The time now is 05:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us