If sheet is visible then...

[Jessica.Bush]

Hi there,

I hope someone will be able to help me please?

My macro currently adds a lot of formulas and things to a huge sheet of data and works great. However things have changed since writing it and now there are about 30 sheets in the workbook, all in the same format that will need the same macro applied.

So I have about 30 sheets which need this macro running across them all and 3 summary sheets which can be ignored. The line I was going down was to hide the summary sheets and do an 'if sheet is visible then do the code' and then making the summary sheets visible again. My problem with this is that it is only applying the code to one sheet and then stopping.

My code to do this is:

Please Login or Register  to view this content.

I would appreciate any help anyone could give please?

Thanks

[mohd9876]

could you post a sample workbook at which the problem occurs

[johnjohns]

See the attached w.book and make the changes to suit your requirement.

[Jessica.Bush]

Hi,

Please find attached an example - I obviously cut lots and have changed it to just two data sheets.

Many thanks.

[Jessica.Bush]

Thanks JohnJohns but I don't think this is what I am after...

[johnjohns]

Try the second macro. I have also used your code

[pike]

or just use the name of the sheets

Please Login or Register  to view this content.

[Jessica.Bush]

Many thanks both of you!

[snb]

Or use Excel's builtin facility 'Fillacrosssheets'

Please Login or Register  to view this content.