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)

Copy Values, not formulas
 

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