I am trying to use the function offset to select the range of B:H Only

But when I use the offset function, the range becomes B:I.

Is there a way to unoffset the offset

Usually with the keyboard shortcut I use, Shift+Right

Range(Selection, Selection.End(xlToLeft)).Offset(0, 1).Select