Not sure, but see if this helps.
XL2000: "PasteSpecial method of Range class failed" Error When Running a
Macro
http://support.microsoft.com/default...90&Product=xlw
HTH
Dana DeLouis
"jason" wrote in message
om...
SUB GGG()
Range("B8").Copy
Range("C8").Select
Selection.PasteSpecial Paste:=xlColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
END SUB
???
JASON