+ Reply to Thread
Results 1 to 11 of 11

Issue with column plus 1 on macro

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Ireland
    MS-Off Ver
    10
    Posts
    19

    Issue with column plus 1 on macro

    Hey all,

    *

    Im running into trouble editing a macro to paste in the next available column, ive tried .Offset(0, 1) but it just keeps pasting in the same place, any help would be greatly appreciated

    *

    Sub Macro2()

    '

    ' Macro2 Macro

    '

    *

    '

    *** ActiveWindow.SmallScroll Down:=-51

    *** Range("C3:C4").Select

    *** Selection.Copy

    *** Sheets("Sheet 2").Select

    *** Range("A2").Select

    *** Selection.End(xlToRight).Select

    *** Range("D2").Select

    *** ActiveSheet.Paste

    *** Sheets("Scoring Sheet").Select

    *** ActiveWindow.SmallScroll Down:=6

    *** Range("G23,G19,G15").Select

    *** Range("G15").Activate

    *** ActiveWindow.SmallScroll Down:=6

    *** Range("G23,G19,G15,G28,G31,G35,G39").Select

    *** Range("G39").Activate

    *** ActiveWindow.SmallScroll Down:=9

    *** Range("G23,G19,G15,G28,G31,G35,G39,G43").Select

    *** Range("G43").Activate

    *** Application.CutCopyMode = False

    *** Selection.Copy

    *** Sheets("Sheet 2").Select

    *** Range("D5").Select

    *** ActiveSheet.Paste

    *** Sheets("Scoring Sheet").Select

    *** ActiveWindow.SmallScroll Down:=12

    *** Range("C49").Select

    * **Application.CutCopyMode = False

    *** Selection.Copy

    *** Sheets("Sheet 2").Select

    *** Range("D13").Select

    *** Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

    ******* :=False, Transpose:=False

    End Sub

    *

    *

    I dont usually write macros i just tend to record so maybe Im way out here but again any advise you can give will help...

    Thanks in advance!

    *

    Tom
    Last edited by Pritirus; 12-21-2016 at 07:17 AM.

  2. #2
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Issue with column plus 1 on macro

    Hi,

    can you pls post an xlm workbook so we can have a loot at your macro?
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  3. #3
    Registered User
    Join Date
    10-21-2016
    Location
    Ireland
    MS-Off Ver
    10
    Posts
    19

    Re: Issue with column plus 1 on macro

    I think I've uploaded it! Thanks!

  4. #4
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Issue with column plus 1 on macro

    not yet!

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    10-21-2016
    Location
    Ireland
    MS-Off Ver
    10
    Posts
    19

    Re: Issue with column plus 1 on macro

    Sorry about that!
    Attached Files Attached Files

  6. #6
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Issue with column plus 1 on macro

    Can you tell us what exactly you are wanting to do?
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  7. #7
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Issue with column plus 1 on macro

    Give this a try

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Issue with column plus 1 on macro

    you have changed the names of your sheets. from Sheet2 into Agent Tracking and that is why is not working.
    Please find it attached. Now i think it will work
    Attached Files Attached Files

  9. #9
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Issue with column plus 1 on macro

    Mike you forgot to add : dim cell as range therefore your code in order to work needs
    Please Login or Register  to view this content.
    Btw your solution is beautiful!

  10. #10
    Registered User
    Join Date
    10-21-2016
    Location
    Ireland
    MS-Off Ver
    10
    Posts
    19

    Re: Issue with column plus 1 on macro

    That works a treat! Thanks so much!

  11. #11
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Issue with column plus 1 on macro

    Please consider:

    If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

    lick the star icon in the lower left part of the contributor's post and add Reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro for user defined report, filtering issue within Macro
    By Mlanger575 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2016, 06:24 AM
  2. Macro security issue - unable to save as macro enabled sheet
    By agadge123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-31-2016, 12:36 PM
  3. Macro security issue - unable to save as macro enabled sheet
    By agadge123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2016, 11:05 AM
  4. [SOLVED] Insert shift down issue macro issue
    By CC64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2012, 10:57 PM
  5. Paste Special Macro issue or macro look up issue
    By notavirusfan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2012, 11:41 AM
  6. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  7. Column Issue with Range
    By jerry8989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2008, 01:33 AM

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