Does a "hasNext" boolean exist for worksheets?

[compulsiveguile]

Is there a way to check the name of the next tab/worksheet following the active worksheet? I'm assuming some sort of method has to exist that can help me.

I'm writing a macro that is compiling and calculating a good deal of data. There are several tabs that are labeled according to date (weeks), and I want to be able to compile data into months on another tab. I thus need to be able to check the label of the next worksheet (in sequential order) to determine whether or not to print the data and reset the values (based off of the name).

I'm hoping to avoid actually creating an example workbook, but if it'd help clarify, I'll whip one up.

Thanks!

[royUK]

Not sure exacly what you want but maybe

Please Login or Register  to view this content.

[compulsiveguile]

Yes, that will work for what I'm trying to do. Thanks!

[royUK]

Glad it helped.