how to resize a range to a specific column : I have data in a range from B2:P10.

If i select a cell (for example c3), what is the vba code to select right to column p (so c3:p3). 

There is text in column q so i cant select right to the 'end'. 

i've tried using offset and resize functions but everything i try is relative and doesnt stop at the absolute of column P