Results 1 to 7 of 7

Macro only works once as range value has changed

Threaded View

kennected Macro only works once as... 03-27-2012, 01:59 PM
Paul Re: Macro only works once as... 03-27-2012, 02:03 PM
kennected Re: Macro only works once as... 03-28-2012, 09:11 AM
kennected Re: Macro only works once as... 03-28-2012, 09:13 AM
Paul Re: Macro only works once as... 03-29-2012, 04:00 PM
kennected Re: Macro only works once as... 04-01-2012, 05:09 PM
Paul Re: Macro only works once as... 04-02-2012, 02:28 PM
  1. #1
    Registered User
    Join Date
    03-24-2012
    Location
    Toledo, Oh
    MS-Off Ver
    Excel 2003
    Posts
    24

    Macro only works once as range value has changed

    I'm trying to build a macro that allows me to add a column, copy data from a static area of my sheet and paste it into the new cells. My problem is 2 things: I don't know enough about Excel, and the fact that the range needed for the next run of this macro has changed since cells have been added and the coordinates have changed.

    Columns("I:I").Select
        Selection.Insert Shift:=xlToRight
        Range("C6").Select
        Selection.Copy
        Range("I6").Select
        ActiveSheet.Paste
    Any help is appreciated.
    Last edited by Paul; 03-27-2012 at 02:01 PM. Reason: Added CODE tags for new user. Please do so yourself in the future.

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