I'm trying to do a paste special (values) of Excel data into an Excel sheet but coding it from word VBA. I can get a normal past to work however with the paste special the 'Paste' argument is not recognised.
I have tried the following (only the paste special line has problems)with no luck and have also tried changing "xlPasteValues" for just "xlValues"
I was wondering if anyone would be able to figure out what I'm doing wrong? Thanks.
With Wb.activesheet .Cells(startRow + (2 * i), 1).EntireRow.Insert Xl.CutCopyMode = False .Range(.Cells(1, 1), .Cells(1, 1).End(xlToRight)).Copy .Cells(startRow + (2 * i), 1).Select .Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=False .Selection.Font.Bold = True End With
If you need any more information please do just ask.