Copy sheet & paste as values

[jwillis07]

Hi all,


I'm getting better with Excel and have gotten pretty good with formulas, but my VB/Macro understanding is limited, if not non-existent!

What I need is to assign a macro to a button so that when executed, it copies the entire sheet and pastes all as values.

Is this do-able and if so, could someone tell me how I would go about this?


Many thanks,

Jason

[mrice]

Use this code in a module (e.g. Module1) - Alt F11 - Insert module

Please Login or Register  to view this content.

On the developer toolbar, hit Insert, button - draw the button and assign the PasteSpecialAll macro to it.

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.

Say thank, click *

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.

Say thank, click *

[jwillis07]

Use this code in a module (e.g. Module1) - Alt F11 - Insert module

Please Login or Register  to view this content.

On the developer toolbar, hit Insert, button - draw the button and assign the PasteSpecialAll macro to it.

Cool, works brilliantly. Thanks a lot mrice!!