colour alternate rows in filtered list

Posted to microsoft.public.excel.programming

RW[_3_]

external usenet poster

Posts: 4

colour alternate rows in filtered list

In VBA, how would I change the interior colour of
alternate rows in a filtered list ie. visible rows only?

Thanks,
Rosemary

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
alternate row shading on filtered data	wallyship	Excel Discussion (Misc queries)	2	October 16th 09 07:11 AM
How do I count rows in a filtered list when using AutoFilter?	chiefcook	Excel Worksheet Functions	6	November 10th 08 09:21 AM
Alternate row shading with a filtered spreadsheet	glenlee	Excel Discussion (Misc queries)	5	December 9th 06 05:57 AM
Define a range containing the first 10 rows of a filtered list	Marco	Excel Worksheet Functions	3	October 7th 05 01:42 PM
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?	Phil A.	Excel Discussion (Misc queries)	1	April 19th 05 04:10 PM

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

About Us