Unhide sheet, calculate and hide

[Macro1]

Hi,

I have a spreadsheet that contains 10 hidden sheets, what I'm trying to do is unhide the first sheet, dump some SQL data in there, perform a calculation, hide the sheet and the perform the same routine on Sheet2.

I already have my SQL data being pulled through and the calculation working, I guess what I'm asking for help on is the piece of code that will wrap around this all telling the code to unhide the sheet, hide it again once the calculation as been performed and then move onto the next one and unhide that one. All the way through until there are no more sheets left.

What I'm trying to avoid is copying out the code 10 times and changing sheet names etc.

Thanks in Advance

[Domski]

Can you post the code that you have so far?

Dom

[Macro1]

Thanks here is the code so far:

Please Login or Register  to view this content.

[Domski]

Sorry, got to go to a meeting but the basic premise around looping through the worksheets in a workbook is like this:

Please Login or Register  to view this content.

Hope that makes some sense, will try and have a look at your code later.

Dom