Posted to microsoft.public.excel.programming

PaulW

external usenet poster

Posts: 130

removing cell formulas

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
REMOVING FORMULAS	FARAZ QURESHI	Excel Discussion (Misc queries)	2	February 3rd 09 01:21 PM
REMOVING WORKBOOK'S ALL FORMULAS	FARAZ QURESHI	Excel Discussion (Misc queries)	3	November 4th 08 11:08 AM
remove figures from a cell without removing the formulas	signature	Excel Worksheet Functions	4	September 14th 06 05:46 PM
Removing Links and Formulas	Chaplain Doug	Excel Programming	3	May 18th 06 04:10 PM
removing formulas	JohnE	Excel Programming	3	March 2nd 04 11:28 PM

All times are GMT +1. The time now is 08:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us