Consulting

Results 1 to 3 of 3

Thread: Cut and Paste Problem

  1. #1
    VBAX Regular
    Joined
    Apr 2007
    Posts
    9
    Location

    Cut and Paste Problem

                        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

  2. #2
    VBAX Contributor moa's Avatar
    Joined
    Nov 2006
    Posts
    177
    Location
    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?
    Glen

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If Col is not "A", I think you might struggle pasting a set of whole rows into none whole rows.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •