Thread: entering formula using variable in Excel Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
doc-s doc-s is offline
external usenet poster
  
Posts: 1
Default entering formula using variable in Excel Macro
Trying to use following in excel Macro and it will not
work. Any help????

ActiveCell.Formula = "=SUBTOTAL(9,P & rowval -1: P &
rowval1)"


where P is column and rowval -1 is current row -1 and
rowval1 are variables.
Reply With QuoteReply With Quote