Reproducing sheets with values only

[Ravi Kumar]

I want to creat a copy from a filled up templet workbook with results /
values only instead of formulas in the templet. In other words the copy of
the templet should contain only result of formulas not formulas. Help Please.

 

[Mike H]

Hi,

Maybe something along these lines

ActiveSheet.UsedRange.Copy
Sheets("Sheet2").Range("A1").PasteSpecial , Paste:=xlValues

Mike

 

[Jacob Skaria]

Hi Ravi

to add on..........if you are looking to do that manually; use Ctrl+A to
select and copy. Target sheet Ctrl+A and Right click Paste special|Values.....

If this post helps click Yes