Copy Values, not formulas

T

Tobias

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)
 
F

Frank Kabel

Hi
have a look at the pastespecial method in the VBA help or
record a macro while doing this manually to see the syntax
of this method
-----Original Message-----
Hello,

Below is a cut from my TransformData macro (I'm switching
Click to expand...
a user-friendly table into a pivot-table friendly list)
'Copy the data for planned to column F
Sheets("Inventory").Select
Range(ThisCol & "2:" & ThisCol & FinalRow).Copy _
Destination:=Sheets("PivotlistaTarget").Range("G" & NextRow)
Sheets("Pivotlista").Select

The problem is that this returns the formulas, I would
Click to expand...
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)
 
Top