Associate
Hi there,
I've searched endlessly on google for an answer but can't find nowt.
Basically I've created a command button in excel and so far so good it copies the Data>Opens a new Workbook and pasts it. I need it so when it pasts the data into the new workbook it pasts as text rather then value. Here is my code:
Whenever I try and edit
to include Format:="Text" there's a bug. Is there anyone that can help me with this problem?
I've searched endlessly on google for an answer but can't find nowt.
Basically I've created a command button in excel and so far so good it copies the Data>Opens a new Workbook and pasts it. I need it so when it pasts the data into the new workbook it pasts as text rather then value. Here is my code:
Code:
Private Sub cmdCopy_Click()
Range("B10:N3000").Select
Selection.Copy
Application.Workbooks.Add
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End SubWhenever I try and edit
Code:
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=Falseto include Format:="Text" there's a bug. Is there anyone that can help me with this problem?