View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Cheung Dennis Cheung is offline
external usenet poster
 
Posts: 20
Default Move the active cell

Dear Sirs,

Can someone help to write a Macro to move the active cell to my designated
location, not by cell reference. But go to somewhere by direction and
distance.

Example: The active cell is B1, but it is variable. I need the active cell
to go to the next cell in its right hand side, it means C1. Or from C1 to D1,
Or from C3 to C4.

Is it possible? Can someone help?
--
Dennis Cheung