N
NDBC
i have copied a worksheet to a new worksheet with
wb.Sheets("A Lap").Range("a1:" & Cells(ARow, MaxA).Address).Copy
wbNew.Sheets("Sheet1").Range("A2")
I just realised the filed are now linked. how do I paste special so that
only the values get saved in the new worksheet.
I gather I have to use this
PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
but don't know where to incorporate it.
Thanks
wb.Sheets("A Lap").Range("a1:" & Cells(ARow, MaxA).Address).Copy
wbNew.Sheets("Sheet1").Range("A2")
I just realised the filed are now linked. how do I paste special so that
only the values get saved in the new worksheet.
I gather I have to use this
PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
but don't know where to incorporate it.
Thanks