Copy Values, not formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop to copy paste rows base on table arrays 0
Macro will copy formula instead of value 6
Copy paste without selecting sheet or range 2
CUT not COPY but errors 8
Copy/Paste_Value problem. 5
Code copies twice...? 13
Array with many cells from a row but not in order or together 11
Copy row info but not in normal column sequence 6

Back
Top