activecell.formulaR1C1 = "='i'!R10C6" 'i is a variable

  • Thread starter Thread starter Mahi
  • Start date Start date
M

Mahi

i cant get the following line working in my VBA programme
please hep me
activecell.formulaR1C1 = "='i'!R10C6"
where i is a variable referencing the sheet index number of all previous
sheets
thank you
Mahi
 
I don't understand what i represents ("the sheet index number of all previous
sheets" confuses me).

But maybe:

dim i as long
activecell.formular1c1 = "'" & worksheets(i).name & "'!r10c6"
 
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

Reference the previous Worksheet in a Formula 3
Creating a variable and pickout data 1
Number and names of courses may change later 3
using variable in setting and ActiveCell 4
vlookup with variable 2
filename as variable 1
File Name changes with dates and Deleting Rows of Zeros 0
macro to copy rows that contain a cell with a certain number 2

Back
Top