| 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 |
| 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 | |||
Threaded Mode
