Thread: Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Ashworth Michelle Ashworth is offline
external usenet poster
 
Posts: 1
Default Macro

I want to be able to look up the changing contents of a
particular cell, move to that value on another worksheet
and then select related cells, then cut and paste to
another location.

I can do exactly what I want, except I always get the same
values being selected, rather than the current value of
the target cell.

How do I tell the Macro to use the value of the cell when
using Edit, Find?