Posted to microsoft.public.excel.programming

John[_78_] John[_78_] is offline

external usenet poster

Posts: 87

Delete all Rows in a Variable Range

How can I delete all Rows in a variable range where the value in Column J
returns Zero and move all Rows below up. Column J contains a formula
relating to other values in the same row.

Thanks

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
Select a range of rows to delete	Donna[_3_]	Excel Worksheet Functions	2	January 26th 10 07:32 PM
Deleting a range of rows based on a variable; syntax error	Babymech	Excel Discussion (Misc queries)	3	January 16th 09 06:19 PM
Variable criteria to delete rows	Jeff Bertram	Excel Programming	18	July 21st 08 07:30 PM
delete rows in range - macro	hindu cliparts	Excel Worksheet Functions	0	November 16th 06 09:54 PM
How to copy&paste a variable range rows and colums	IK	Excel Discussion (Misc queries)	1	August 30th 06 12:06 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us