SIMPLE copy (Excel xp)

Topic

New Reply

It’s been so long since I’ve touched anything to do with VBA that I can’t even think of the best way to do this.

Very simple, I just want to copy from a range name CURRENT and paste value to a range name PREVIOUS.

Very easy to record it, but it looks pathetic.

Thanks

Reply | Quote

Replies

Like this:

Sub test()
With ThisWorkbook
.Names(“CURRENT”).RefersToRange.Copy Destination:=.Names(“PREVIOUS”).RefersToRange
End With
End Sub

Reply | Quote

Thanks…but just to clarify, I need this to paste-value the range as the cells within CURRENT contain formulas.

Reply | Quote

Now you tell me .

Sub test()
With ThisWorkbook
.Names(“CURRENT”).RefersToRange.Copy
.Names(“PREVIOUS”).RefersToRange.PasteSpecial Paste:=xlValues
End With
End Sub

Reply | Quote