Macro to transform formulas into values across multiple tabs

[loulite]

Hi everybody,

I have never written a macro and when I record one I usually have trouble with the relative references.
I am trying to write a macro to transform formulas into values every month.
I want to transform formulas:
- across a range of tabs: each tab is exactly alike and is named page-1 to page 25
- on a different column every month (same column across all tabs)
- on the same rows: L168 to L227 and L266 to L277 (same rows across all tabs)

Can anyone help?
Thanks!!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Armando Montes]

One way:

Please Login or Register  to view this content.

[loulite]

Thanks for your answer! How does this macro identify the column I want to change into values?

[JOHN H. DAVIS]

Thanks for your answer! How does this macro identify the column I want to change into values?

Which Post are you refering too?

[loulite]

Hi John, I was refering to your first post from feb 7th at 3.51pm
Thanks

[JOHN H. DAVIS]

Hi John, I was refering to your first post from feb 7th at 3.51pm
Thanks

The Column is indicated in red:

Please Login or Register  to view this content.

The formulas in the ranges in Column L as specified in Post1 will change to values for each sheet "Pages 1 - 25"