NYC_Rick2008
New Member
- Joined
- Oct 24, 2011
- Messages
- 1
I was trying to write VBA code to paste special value of one column to a column under seperate worksheet. The destination column has a drop-down list feature and the paste sepcial I used just overwrote the drop-down list feature but I want to keep the drop-down list feature. Anyone can assist?
below is my coding:
Inputbook.Worksheets("PortfolioData").Range("CD8:CD20000").Select
Selection.Copy
destsheet.Range("AA8").PasteSpecial _
Paste:=xlPasteValues
Application.DisplayAlerts = False
Application.DisplayAlerts = True
below is my coding:
Inputbook.Worksheets("PortfolioData").Range("CD8:CD20000").Select
Selection.Copy
destsheet.Range("AA8").PasteSpecial _
Paste:=xlPasteValues
Application.DisplayAlerts = False
Application.DisplayAlerts = True