+ Reply to Thread
Results 1 to 3 of 3

How to keep column data location after insert column?

  1. #1
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    How to keep column data location after insert column?

    In looping, I had located data in some column e.g. range("aa" & row), range("ab" & row-1). now I want to insert a new column before column AA on spreadsheet and hope original data will be relocated automatically i.e. range("ab" & row), range("ac" & row-1) without re-edit the code. How to do it? thanks.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,576

    Re: How to keep column data location after insert column?

    Assign your range to a range variable.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: How to keep column data location after insert column?

    Very useful, Thanks you for your help. I am going to label each data columns to replace set MyRng(s).

+ Reply to Thread

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