Posted to microsoft.public.excel.programming

K[_2_]

external usenet poster

Posts: 557

copy rows based on cell colour

Hi, can anybody please able to tell me the macro that how can i copy
rows to another sheet on based on cell colour. Like if i have
"Interior.Colorindex = 3" or Red in cell B1,B3 and B7 so how can i
copy those colored rows which should be not entire row but from Cell
A
to Cell F in length to any other sheet. Please anybody can help it
will be very helpful.... 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
copy rows based on cell colour	K[_2_]	Excel Programming	1	December 13th 07 11:04 PM
Copy rows based on cell content	billinr	Excel Discussion (Misc queries)	2	February 14th 07 08:17 PM
Copy rows from one sheet to another based on a cell value	SM1	Excel Worksheet Functions	1	December 21st 06 01:01 AM
Copy rows from one sheet to another based on a cell value	SM1	New Users to Excel	1	December 21st 06 01:00 AM
copy rows based on cell value	Przemek	Excel Programming	2	August 22nd 05 08:46 AM

All times are GMT +1. The time now is 07:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us