removing cell formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with all cells containing formulas and their corresponding
values. I want to make a copy this worksheet in the same workbook with only
their values and without their formulas. Kindly advise
 
If i understand you correctly you can just hit CTL A to select all, copy, and
then use the option Paste Special and check the Values box on the new page
where you want the data.
 
Since you asked in programming:

activesheet.copy worksheets(worksheets.count)
with worksheets(worksheets.count)
.cells.copy
.cells.Pastespecial xlValues
End with
 
Sheets("Sheet2").range("A1:IV65000") =
Sheets("Sheet1").range("A1.IV65000").value
 
You must log in or register to reply here.

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

Excel VBA 1
pasting values only 1
Excel Count If Formula Question 1
simple code but it doesn't look like usual vba code 2
Copy/Paste Template to New Workbook 11
Special Copy, Paste Special macro 3
Select and copy only cells with values, open an app, paste into 2
Need Macro... 8

Back
Top