How do I make this range that I copy using my macro relative to the
cell I select. If I am at cell B4, I want it copy B4:U4.

Range("B1:U1").Select
Selection.copy

Thanks