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

's Computer Specifications

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

's Computer Specifications

ActiveCell.FormulaR1C1 = "='" & i & "'!R10C6"

"Mahi" wrote:

> 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

's Computer Specifications

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"

Mahi wrote:
>
> 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

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ActiveCell.FormulaR1C1 = "=SUM(R[-tellerteller]C:R[-1]C)"	Jack Sons	Microsoft Excel Misc	5	29th Sep 2009 09:58 PM
.FormulaR1C1="abc" works, .Text="abc" doesn't. WHAT the?	baobob@my-deja.com	Microsoft Excel Programming	5	22nd Aug 2008 10:51 PM
Substitute variable in a VBA ActiveCell.FormulaR1C1	=?Utf-8?B?Um9Cbw==?=	Microsoft Access VBA Modules	1	30th Jul 2007 12:42 PM
ActiveCell.FormulaR1C1 = "=IF(c4:c4<='Title Page'!$B$19,1,0)" ?? HELP!!!	harteorama@googlemail.com	Microsoft Excel Programming	4	29th Dec 2006 11:35 AM
ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"	Jordi	Microsoft Excel Programming	4	12th Nov 2003 01:26 PM