Hello everyone,
I am trying to call the first available or active cell under a column and start the calculation from there.
so for example, in this picture:
the first active cell under column y is 48.5 and from there i can start my calculation for column Z ( taking into account that the first active cell in column y does not have to be row 5, it could be in row 6, 8, 1 or whatever row) I would like to know how to call the active cell on vba when calculating for a new value?
Thanks,
I am trying to call the first available or active cell under a column and start the calculation from there.
so for example, in this picture:
the first active cell under column y is 48.5 and from there i can start my calculation for column Z ( taking into account that the first active cell in column y does not have to be row 5, it could be in row 6, 8, 1 or whatever row) I would like to know how to call the active cell on vba when calculating for a new value?
Thanks,