One way:
Range(cell_address).Activate
Or, if the cell could be on a different sheet:
Application.GoTo Range(cell_address)
In article ,
blkane wrote:
My workbook is formula driven and the tables will dynamically expand or
contract with the size of the data. I have a need to move to the next
available row before starting the next subroutine. I have created a formula
that computes the correct cell address but I don't know how to structure a
goto command within the macro to use it.
|