thanos54321
Programmer
Hi all,
I'm working on a code that runs through several sheets with the same code. In the end of the loop, there is a code like:
ActiveSheet.Next.Select
Obviosly, this will make the code crash with an error message when there are no more sheets.
What I'd like the code to do is to end without an error message when the ActiveSheet.Next.Select statement is false. This seems rather simple, but for some reason it has eluded me so far. Anybody got time to look at this? Thanks a bunch!
Thanos54321
I'm working on a code that runs through several sheets with the same code. In the end of the loop, there is a code like:
ActiveSheet.Next.Select
Obviosly, this will make the code crash with an error message when there are no more sheets.
What I'd like the code to do is to end without an error message when the ActiveSheet.Next.Select statement is false. This seems rather simple, but for some reason it has eluded me so far. Anybody got time to look at this? Thanks a bunch!
Thanos54321