Copy and Paste Special in all worksheets

[JohnnyBGood]

Hi All,

I want to be able to automatically go through each sheet (including hidden ones) and copy the used ranges and paste special values and formats in each.

Is there a code anyone could provide to do this.

Thanks.

[Jbm444]

I do not recommend using usedrange, but here's

Please Login or Register  to view this content.

That will work, but here's a crack at not using .usedrange. I just can't get the syntax right on three copy/paste lines, denoting the range. Unless someone corrects my syntax though, use the code above (despite its use of .usedrange).

Please Login or Register  to view this content.

[JBeaucaire]

One easy way to remove all formulas from all sheets:

Please Login or Register  to view this content.