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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Sanjiv" wrote:

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

Hi,

Ctrl+A
Ctrl+C
Edit|paste special|select values. OK

Mike

"Sanjiv" wrote:

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

Since you asked in programming:

activesheet.copy worksheets(worksheets.count)
with worksheets(worksheets.count)
.cells.copy
.cells.Pastespecial xlValues
End with

--
Regards,
Tom Ogilvy


"Sanjiv" wrote:

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

Sheets("Sheet2").range("A1:IV65000") =
Sheets("Sheet1").range("A1.IV65000").value

"Sanjiv" wrote:

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