| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Two Variables in Excel Calculation VBA
Having trouble getting correct syntax. Using two inputted variables
TotSalesDay and CurrSalesDay - need to calculate in cell ActiveCell.FormulaR1C1 = "=RC[-2] / TotSalesDay * CurrSalesDay -- Rita |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Two Variables in Excel Calculation VBA
ActiveCell.FormulaR1C1 = "=RC[-2] / " & TotSalesDay & " * " &
CurrSalesDay HTH Charles Rita wrote: Having trouble getting correct syntax. Using two inputted variables TotSalesDay and CurrSalesDay - need to calculate in cell ActiveCell.FormulaR1C1 = "=RC[-2] / TotSalesDay * CurrSalesDay -- Rita |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Is it possible to use variables in Excel? | Excel Discussion (Misc queries) | |||
| How do I use variables in Excel? | Excel Discussion (Misc queries) | |||
| How do I use variables in Excel? | New Users to Excel | |||
| can i get excel to add variables | Excel Worksheet Functions | |||
Linear Mode
