setting range with current cell RRS feed

  • Question

  • I suspect this is easy, and I've just been looking at code too long...

    I need to set a range from the active cell to the 'lastcolumn -2' (effectively, i need the range to end two columns prior to my last column).

    For example, if my active cell is "B3", and my lastcolumn (which is a defined variable) is "B8", I want my range to be "B3:B6".  Basically, "B3:" & LastColumn-2.

    But, I'm struggling with setting the current cell.

    Any help is appreciated!


    Wednesday, September 9, 2015 8:44 PM