View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default 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