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.
![c072632.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgsafe.org%2Fc072632.jpg&hash=1ef93602ed7737c3ecbbf07b3c71a259)
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,