View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren[_2_] Darren[_2_] is offline
external usenet poster
 
Posts: 9
Default Creating a formula which references a dynamic cell location

I have a routine for which variables "t" & "s" have a value.

I would like Visual Basic to be able to enter a formula into the
active cell so that it equals whatever value may be contained in cells
(t,s) of the worksheet.

I tried:

Activecell.FoumulaR1C1 = "=R[t]C[s]"

but it is not working.

Any ideas would be much appreciated.