kbay808
asked on
How do I set the destionation for a vba code to cell A4.
I have a vba code that will paste just the text into a cell from the clipboard, but I need the destination to be A4.
Sub Paste_Unformatted()
If Application.CutCopyMode = xlCopy Then
ActiveCell.PasteSpecial Paste:=xlPasteValues
Else
ActiveSheet.PasteSpecial Format:="Text", _
Link:=False, _
DisplayAsIcon:=False
End If
End Sub
ASKER
I'm receiving an error. Please see the attached screen shot.
Error-Screen-Shot.jpg
Error-Screen-Shot.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked perfect!!! Thank you very much.
pls try
Open in new window
Regards