| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activecell.formulaR1C1 = "='i'!R10C6" 'i is a variable
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activecell.formulaR1C1 = "='i'!R10C6" 'i is a variable
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activecell.formulaR1C1 = "='i'!R10C6" 'i is a variable
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.FormulaR1C1 = "=SUM(R[-tellerteller]C:R[-1]C)" | Excel Discussion (Misc queries) | |||
| Replace(ActiveCell.Formula, "Round(","") not working as expected | Excel Programming | |||
| ActiveCell.FormulaR1C1 = "=IF(c4:c4<='Title Page'!$B$19,1,0)" ?? HELP!!! | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]" | Excel Programming | |||
Linear Mode
