Copy/Paste only values

[Session101]

Hey guys,

How do I copy and paste values only in VBA using the .Copy method?

My current code is listed below, but it does a normal copy/paste:

Please Login or Register  to view this content.

Thanks!

[davegugg]

To do that you need to break it into two lines like this:

Please Login or Register  to view this content.

[Leith Ross]

Hello Session101,

You can do this two different ways. First, you can modify your copy statement to use PasteSpecial.

Please Login or Register  to view this content.

The second way is by direct assignment. This method only works with the Value property. Eventhough the Value property is the default property for a Range, you still must specify the property for the block transfer to work.

Please Login or Register  to view this content.