View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChrisR ChrisR is offline
external usenet poster
 
Posts: 8
Default Refer to ActiveCell

I want a given cell eg z100 to constantly - or at each recalculation - to
hold the contents - or reference - of ActiveCell (so a text box can highlight
it.). My code does it but only once at each run of the module, then it sticks
or throws an error.