jsc0624
04-12-2007, 06:44 AM
Rows(X).Select
Selection.Cut
Sheets("FuelNotValidEntry").Select
Range(Col & X).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheets("Fuel").Select
What's wrong with this code? There is a message that appears:
PasteSpecial Method of Range class failed
Selection.Cut
Sheets("FuelNotValidEntry").Select
Range(Col & X).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheets("Fuel").Select
What's wrong with this code? There is a message that appears:
PasteSpecial Method of Range class failed