| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Image references in a cell | Excel Programming | |||
| Using Dynamic Cell Address As Formula Location | Excel Worksheet Functions | |||
| dynamic cell references | Excel Worksheet Functions | |||
| dynamic cell references in formulas | Excel Programming | |||
| Dynamic Cell References | Excel Programming | |||
![Darren[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
