copy then paste as values on multiple selections

[esbencito]

Hi all,

I'm using a macro to copy and paste ranges as values once they have been recalculated, however, there are multiple selections, hence it returns an error when running the code. Is there a workaround for that? I currently use:

Please Login or Register  to view this content.

but instead want to use:

Please Login or Register  to view this content.

[sintek]

One other way...Not simpler

Please Login or Register  to view this content.

[esbencito]

One other way...Not simpler

Please Login or Register  to view this content.

Indeed not simpler at all. I did some more research and found the following code that works great for one range:

Please Login or Register  to view this content.

However, how would I now use two ranges? Below doesn't seem to work...

Please Login or Register  to view this content.

[sintek]

As far as I know it is not possible to copy non contiguous ranges and paste as values over themselves...

[esbencito]

But

Please Login or Register  to view this content.

isn't copy and pasting...?

[sintek]

Try...Untested

Please Login or Register  to view this content.

Edit
Nope, does not work

Your ranges are not same length