Hi All,
First off, very basic knowledge/use of macros.
I have data in Columns C10:C12, which is based off data from other worksheets (eg. =Sheet2!$C$5).
Now, I want to move this data to D10:D12, but when I do this, the formula reference gets deleted as well (eg. =Sheet2!$C$5)
Below is the code:
Sub ClearCurrentData()
Range("C10:C12").Copy Range("D10") 'COPY FROM C AND PASTE TO D
Range("C10:C12").Copy 'COPY COL C
'PASTE THE VALUES TO RIGHT IN LAST BLANK COLUMN TO RIGHT OF I10
Range("I10").End(xlToRight).Offset(0, 1).PasteSpecial xlPasteValues
'CLEAR CONTENTS OF C
Range("C10:C12").ClearContents
'ACTIVATE THE 1ST CELL
Range("C10").Select
End Sub
Question is: any way i can do this without the formula being deleted? Using excel 2016
Any help would be appreciated
thank you
Bookmarks