Using Two Variables in Excel Calculation VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having trouble getting correct syntax. Using two inputted variables
TotSalesDay and CurrSalesDay - need to calculate in cell

ActiveCell.FormulaR1C1 = "=RC[-2] / TotSalesDay * CurrSalesDay
 
ActiveCell.FormulaR1C1 = "=RC[-2] / " & TotSalesDay & " * " &
CurrSalesDay

HTH

Charles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Geometric progression in VBA 10
how to use VBA variable in formula? 4
Use a Variable in a formula 4
Help with my VBA and formula 8
Trendline Coeeficients Vba Procedure 3
Syntax for a formulae in Visual Basic 2
Syntax in worksheet functions for individual values instead of ranges 5
"=TEXT(RC[-1],"MMM")" 4

Back
Top