Results 1 to 6 of 6

1004 This selection is not valid.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2010
    Location
    India
    MS-Off Ver
    2010
    Posts
    268

    1004 This selection is not valid.

    Hi

    I am a newbie to macros, and this is my first post to this group.

    I am trying to move columns in an excel, and hitting error 1004.
    This is the relevant portion of code:

    Columns(FoundAtColName & ":" & FoundAtColName).Select
    Selection.Cut
    Columns(Chr(Asc(p_dest_col) + 1) & ":" & Chr(Asc(p_dest_col) + 1)).Select
    Selection.Insert Shift:=xlToRight
    Application.CutCopyMode = False
    Can someone help me resolve this?

    Thanks in advance
    Ajay
    Last edited by Paul; 03-11-2010 at 01:11 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1