Thread: Using Two Variables in Excel Calculation VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default 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 With QuoteReply With Quote