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