Im trying to get the macro to look through sheets 1 to 16 and show the message box if conditions are met the code works ok but only looks up the active sheet not the 16 sheets , heres my code
Please Login or Register to view this content.
Im trying to get the macro to look through sheets 1 to 16 and show the message box if conditions are met the code works ok but only looks up the active sheet not the 16 sheets , heres my code
Please Login or Register to view this content.
Hi, rjm87,
wouldn´t it be easier to use an Autofilter for each sheet and work on only the displayed rows instead of looping through nearly 6000 rows?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks that does the job , I put an extra 0 in meant to be 600.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks