Autofill Formula down a Column across multiple worksheets

[Rikkdh]

I have a workwook with multiple worksheets - I'm calling the macro to copy the formula down the column(s).

I'm having a problem replacing the active cell references from the recorded macro and passing in the correct worksheet references.

Here's the macro calling the various macros:

Please Login or Register  to view this content.

and here's the one i'm having problems with:

Please Login or Register  to view this content.

Just not sure if this is the smartest way of doing this, or if im using the righth ws references here! cant seem to get my head round them! any help, gratefully received! Thanks

[Winon]

Hello Rikkdh,

Good going so far. Keep on trying.

Just check this line:

Please Login or Register  to view this content.

and change it to

Please Login or Register  to view this content.

[Rikkdh]

yeah, typo on my part...

so when corrected, it works on the active worksheet thats selected...

Trouble is that I want to Call it to run as on its own so it runs on all 20 worksheets in the workbook....

Please Login or Register  to view this content.

not sure where to pass in the worksheet referneces to get it to do this, can anyone point me in the right direction?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.