View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SHIPP SHIPP is offline
external usenet poster
 
Posts: 29
Default Dynamically create a formula in Sheet B referencing SheetA

I am writing a scheduling program. What I want to do, through VBA, is to
create a formula in Sheet B that references a cell in Sheet A. In essence I
want to put a formula:
=MASTER!B15

in a cell in Sheet B through VBA so that if the value in Sheet A changes,
the value in Sheet B will also change. I cannot simply create the formula in
Sheet B because Sheet A changes dynamically.

Thanks in advance for any help.

--
M. Shipp