LinkBack URL
About LinkBacks
I want my macro to loop through the sheets in my workbook until it finds one that is green.
I tried:
But it didn't work. Any ideas?
Do Until ActiveWorkbook.Sheets(i)Tab.ColorIndex = 50 i = i + 1 Sheets(i).Select Loop
Loop through sheets until tab colour is green
I want my macro to loop through the sheets in my workbook until it finds one that is green.
I tried:
But it didn't work. Any ideas?Do Until ActiveWorkbook.Sheets(i)Tab.ColorIndex = 50 i = i + 1 Sheets(i).Select Loop
Last edited by mattsgr1; 03-28-2007 at 06:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks