I want to select a Blank Cell in a range
Please see the attached sheet. In the sheet I would like to select Cell I15.
I am aware of selecting with the formula
But what I need is to select with XL(end) formula.
I have done some work that can be seen in the module, however I am even placing my requirments here.
Code
Set AA = Range("D8").End(xlToRight).Offset(2) this selects Cell I10
But I want with XLformula something like below to select cell I15 BUT THE FORMULA BELOW DOES NOT WORK
Set BB = Range(AA.Address & Range("C" & Rows.Count).End(xlUp).Row)
I would then use the above in the formula as below
Range(aa.address & ":" & bb.address).select
Display More