Running This Macro on all of my pages

[seannydj]

Hi all,

I am very new to macros and I was wondering how you could run the macro I just made across all of my pages in the document? Any ideas?

I have attached the document, thanks for your help in advance!

-Sean

[john456852]

go to the view tab and click macros, view macros, and then after clicking the macro, press run

[seannydj]

I'm guessing I did something wrong. When I do that it will only run the macro for the sheet I am on...

[Norie]

Sean

The code starts with this.

Please Login or Register  to view this content.

What cell is ActiveCell?

Should it actually be D1?

Also, in the next line you auto fill to D1:D10.

Not all sheets have 10 lines of data, some have less.