Change Workfile Page automatically?!
Posted: Mon Jan 30, 2012 3:27 am
Hey Guys! I have a quite lenghty program that is to be applied to every page of a worksheet.
As there are many pages (and many worksheets) i would like to know whether there is a command which automatically changes to the NEXT page in
the active worksheet, so the programme runs over this next page...and the next and so on.
something like
for "page = 1 to 99"
"execute program on the series in this page"
"next page"
....until the last page has been finished!
The pages are not numbered numerically 1,2.... but with descriptions (EURUSD_POS, EURUSD_NEG, USDJPY_POS....
Cheers, thanks you for help!
As there are many pages (and many worksheets) i would like to know whether there is a command which automatically changes to the NEXT page in
the active worksheet, so the programme runs over this next page...and the next and so on.
something like
for "page = 1 to 99"
"execute program on the series in this page"
"next page"
....until the last page has been finished!
The pages are not numbered numerically 1,2.... but with descriptions (EURUSD_POS, EURUSD_NEG, USDJPY_POS....
Cheers, thanks you for help!