Results 1 to 7 of 7

Shift contents of cells over one column

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Markham, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Shift contents of cells over one column

    I am writing a macro that will among other things, move a range of cell data over one column. I am attempting to do something like this:

    Range("AJ:BE").rows(ActiveCell.Row).Cut
    Range("AK:BF").rows(ActiveCell.Row).Paste
    but the .Paste line gives me an error.

    Run time error '438':
    Object doesn't support this property or method.

    Attempting to use PasteSpecial also gives me a (different) error.

    I have googled some examples of code snippets that seem to do the same thing, so I believe I must be missing something obvious, but a few hours of poking at this hasn't yielded results. Any help would be appreciated.

    Chris
    Last edited by jeffreybrown; 11-21-2012 at 06:23 PM.

Thread Information

Users Browsing this Thread

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

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