Using a Variable in a Formula

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I want to modify the following formula to use a variable
as the row reference:

ActiveCell.FormulaR1C1 = "=SUM(R[-139]C:R[-1]C)"

The variable is declared as Dim Bottom as Integer

The value is set as
Bottom = ActiveCell.Row

Can someone tell me the syntax to use in the formula to
use "Bottom" in place of "139"? Everything I've tried has
failed.
 

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

Int Variable into R1C! Formula 1
Sum using Variable 4
R1C1 Formula 1
Run-time error '1004': Application defined or Object defined error 2
Cleaner coding to repeat process 6
Use of Variable in Sum 5
variables inside a formula?? 2
R[1]C[1] with a variable 2

Back
Top