Using stored variable in a formula

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

Hi. i have managed to store the active sheet name in a variable. how
do i use this variable in a formula?
 
Here is what the formula look like in the spreadsheet

=SUM(Sheet2!A1:A5)

To generate this in VBA

MySheetName = "Sheet2"

Range("A1").formula = "=SUM(" & MySheetName & "!A1:A5)"
 
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

Use cell contents to make formula reference 4
VBA to run all variable combinations in a calculation model and store result 6
ActiveSheet in formula 2
how to store values in a 2 dimensional array 2
How to create a bubble chart with more than 2 variables 0
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1
Simple Variable to someone 5
Use external file variable in formula 2

Back
Top