Cut and Paste Problem

[jsc0624]

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

[moa]

Range("Col" & X).Select at a guess. Well, it's something to do with the range.

What are your variables and what values do they hold?

[Bob Phillips]

If Col is not "A", I think you might struggle pasting a set of whole rows into none whole rows.