Hi and thanks in advanced.
I have the data set
ColA ColB ColC ColD ColE ColF ColG ColH ColI
Row 1 x blank cell x blank cell X blank cell x blank cell
I want to select the range ("A1:I1") however the data may not always end in column I so for another sheet the data may end in col Q.
Is there a code that can select this range based on the data in row 1?
I have the data set
ColA ColB ColC ColD ColE ColF ColG ColH ColI
Row 1 x blank cell x blank cell X blank cell x blank cell
I want to select the range ("A1:I1") however the data may not always end in column I so for another sheet the data may end in col Q.
Is there a code that can select this range based on the data in row 1?