Posted to microsoft.public.excel.programming

external usenet poster

Posts: 389

Locate last row containing ColorIndex 35

I am using Office 2003 on Windows XP.

I need to find the bottom-most row in a sheet - any column - that contains
an interior color index of 35. Is a "For Each" over all cells the only/best
way?

Could someone please post example code?
Thanks much in advance

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
colorindex	Nell Fahey	Excel Discussion (Misc queries)	3	April 28th 05 07:06 PM
ColorIndex	Trevor Davidson	Excel Programming	5	April 26th 04 10:39 PM
ColorIndex	K Bro	Excel Programming	2	February 7th 04 04:42 PM
ColorIndex	K Bro	Excel Programming	0	February 7th 04 03:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us