Copying values not formulas

Posted to microsoft.public.excel.programming

Joe M.[_2_] Joe M.[_2_] is offline

external usenet poster

Posts: 3

Copying values not formulas

I have the following piece of code

Here.EntireRow.Copy Destination:=There

This copies the formulas that are in this row, I need to
know how to modify this code to copy values instead of
formulas.

Any help?

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
Copying values/formulas from only visable lines when filters are o	excelchallenged	Excel Worksheet Functions	0	March 16th 10 05:08 PM
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP	Sherberg	Excel Worksheet Functions	4	September 11th 07 01:34 AM
Drop and drag is copying values instead of formulas	joel1972	Excel Worksheet Functions	5	September 15th 06 11:01 PM
copying formulas and not values	peets	Excel Worksheet Functions	2	March 21st 06 08:43 PM
Why do formulas turn to values wen copying in Excel 2003...	zyphyl	Excel Worksheet Functions	1	November 6th 04 06:33 AM

All times are GMT +1. The time now is 08:13 AM.

Menu

About Us