Currently the code looks like this, and it works:
Range("C2").Select
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
however I would like to do the same without selecting the cell. so I tired this:
Range("C2").PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
however I got the "Named argument not found." error message. Is there a way of pasting text this way without selecting the cell? (The source of my text is a macro, so text cannot be pasted the same way as it could be if the source was a cell.)
Thanks
Bookmarks