View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.