View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default How do i refer to cell contents in a macro?

I am a novice and i am trying to write a macro to position the sheet at a cell.
The cell reference that i want to go to is a variable which is the
calculated content of another cell (CELL 2). How do i insert the CONTENTS of
cell 2 (address I want to go to: i.e. R45) into the macro so it works
properly?