Results 1 to 4 of 4

Move Cell Locatin in a Macro

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Move Cell Locatin in a Macro

    Below is my the macro that I recorded. I want to copy and paste the same information to a new location everytime. The macro tells it to go to cell IV1, end left, then I want it to go right one cell regardles of the cell location. Here it tells it to got to ("K1"). It will do this everytime and I do not want it to go to K1, just move right one time and then paste the information.

    Sub Cost()
    '
    ''
        Columns("A:J").Select
        Selection.Copy
        Application.Goto Reference:="R1C152"
        Selection.End(xlToLeft).Select
        Range("K1").Select
        ActiveSheet.Paste
        Range("T3").Select
        Application.CutCopyMode = False
        Selection.ClearContents
        Range("T2").Select
        Selection.ClearContents
        Range("N5,N6,P5,P6,N8,N9,P8,P9,N13,P13,N15,P15,N17,P17").Select
        Range("P17").Activate
        Selection.ClearContents
        Range("T3").Select
    End Sub
    Any Help will be appreciated
    Last edited by Excel Wanna Be; 03-30-2009 at 02:44 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