Paste Special

S

Sandy

I have the following code (courtesy of this newsgroup) which works fine
other than it copies the formulas, rather than the values, - which are what
I require.
I am sure it needs the equivalent of paste special but I don't know how to
achieve that.

"Set SourceRange = Sheets("RecordOfRoundsDetailed").Range("A45:FK45")

Set DestSheet = Sheets("RecordOfRoundsDetailed")

Lr = LastRow(DestSheet)

Set DestRange = DestSheet.Range("A" & Lr + 1)

SourceRange.Copy DestRange"

All help appreciated.
Sandy
 

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

Copy to last row macro 4
transfer macro 5
Copy to Next Blank Row 5
Copy an array of Sheets 4
Lastrow - function not defined 2
this code crashes excel. How come? 3
Arrays and Loops 3
automatically run script 2

Top