Macro to select cell based on formula
Hello all,
I record macro's the lazy way, but recording them. Typically this is fine as all actions are recorded by the mouse controls, but I would like to have the first step in the macro select the last cell containing a value in a row, then selecting a vertical range below that cell.
Any idea how to attack this?
Thanks in advance
|