Posted to microsoft.public.excel.programming

Dan Thompson Dan Thompson is offline

external usenet poster

Posts: 125

How can I selectivly delte rows with a macro ?

Hi there I have been looking for a simple way to delete rows that are
highlighted a certain color for example.

I have a worksheet where Rows 10 to 15 and 100 to 200 are interior
colorindex 4 What I would like to know is how to make vba delete all rows
that are not colored green so that only the green ones remain at the top of
the spreadsheet.

??
Dan Thompson

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 to Delte Multiple Rows Given a Value Existing	Jako[_91_]	Excel Programming	1	October 24th 04 12:57 PM
How to Delte Multiple Rows Given a Value Existing	Jako[_90_]	Excel Programming	1	October 24th 04 12:32 AM
How to Delte Multiple Rows Given a Value Existing	Jako[_89_]	Excel Programming	0	October 23rd 04 09:52 AM
How to Delte Multiple Rows Given a Value Existing	Jako[_88_]	Excel Programming	1	October 22nd 04 11:34 PM
Delte blank rows between different sections of data	Steven R. Berke	Excel Programming	2	July 27th 03 01:06 AM

All times are GMT +1. The time now is 04:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us