Posted to microsoft.public.excel.programming

Tobias[_2_] Tobias[_2_] is offline

external usenet poster

Posts: 11

Copy Values, not formulas

Hello

Below is a cut from my TransformData macro (I'm switching a user-friendly table into a pivot-table friendly list

'Copy the data for planned to column
Sheets("Inventory").Selec
Range(ThisCol & "2:" & ThisCol & FinalRow).Copy
Destination:=Sheets("PivotlistaTarget").Range("G" & NextRow
Sheets("Pivotlista").Selec

The problem is that this returns the formulas, I would like it to return only the values. (It is a very big list and it is very time consuming to add $-signs in the entire Inventory-list)

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
Copy a file with only values no formulas	Lee Coleman	New Users to Excel	2	April 6th 07 04:43 PM
copy formulas without associated values	dranreb	Excel Worksheet Functions	0	April 3rd 06 10:22 PM
Copy formulas, not values	Fred Smith	Excel Programming	2	February 21st 04 04:39 PM
How to Copy Formulas not Values ...	Ronnie[_2_]	Excel Programming	2	October 23rd 03 08:37 AM
Range COPY function - how to copy VALUES and not formulas	James Cooke	Excel Programming	1	August 21st 03 07:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us