sheets array

  1. J

    Sheets(Array) help needed. 84 worksheets trying to run with code but limit seems to be 75, how to overcome 'too many line continuations' error?

    Good evening the ever amazing MrExcel community :), I have another problem I am trying to overcome....I have a workbook with 95 worksheets of which I need to save 84 on a monthly basis as a pdf and distribute to the business. Current WoW is just to select the tabs and save manually but looking...
  2. K

    Sum of same cell on multiple sheets

    Hi, I have this formula that works =SUM('ETU1:ETU9'!G30) but I need the 9 to be dynamic. Its value is in cell F19 of the same sheet. I therefore try to get [CODE]=SUM(indirect("'ETU1:ETU"&F19&"'!G30")) but that does not work. Can you spot what is wrong?
  3. T

    VBA - Choose sheets in workbook to print as one PDF file

    Hello, I have an application to be used by basic level users of Excel. The app will produce a set of analytics on about 20 separate worksheets. Not all users will want all 20 sheets and so I need a clean method to allow each user to select which pages they would like to print and these to then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top