entering formula using variable in Excel Macro

  • Thread starter Thread starter doc-s
  • Start date Start date
D

doc-s

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.
 
Hi
try:
ActiveCell.Formula = "=SUBTOTAL(9,P" & rowval -1 & ":P" &
rowval1 & ")"
 
You must log in or register to reply here.

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

The Error That Stumps Me 3
Did LostFocus ever exist or is just a dream?! 7
visual basic conditional formatting produces strange results 3
91 object variable or with block variable not set 6
Intersect Code too slow HELP 4
Ranges in VBA 4
Loop is slow trying array code 17
Arrey VAriable - How to initialise 1

Back
Top