Vba Code To Move To Next Column

  • I need to set up a macro to copy and paste a column to the next blank column to the right. I have used <ctrl right arrow> which gives the VBA code

    Code
    1. Selection.End(xlToRight).Select


    but this only takes me to the last FILLED column - I need to move to the next column - when recording the macro and pressing the right arrow, it specifies the actual column number - I want this to be generic so that it can fill up the columns to the right day after day. I am sure this is very easy, but so far all my searches have been to no avail.:(

  • Re: Vba Code To Move To Next Column


    Try

    Code
    1. cells(selection.row, columns.Count).end(xltoleft).offset(,1).select

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]