Reproducing sheets with values only

  • Thread starter Thread starter Ravi Kumar
  • Start date Start date
R

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.
 
Hi,

Maybe something along these lines

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

Mike
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save column J of WorkBook when WorkBook is not saved. 2
How do I export data from excel to Powerpoint by macros in excel 1
Loop until a unique worksheet name is entered 3
How to multiply time by monitary value 1
How to use =sumallsheets(b1)? 2
adding a page to a template 1
year end sales report with old and new customers 1
How can i make a custom templet in excel? 1

Back
Top