I can't believe how hard it is to find something that I think should be simple... if it wasn't for these forums I would go nuts!!
Ok... all I want to do is something like this.
However, I don't want to select the entire row... just the active cell and 11 to the right should be selected.![]()
Range("B3").End(xlDown).Offset(1, 0).Select ActiveCell.Offset(1, -1).Select Rows(ActiveCell.Cells).Select
Bookmarks