View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mahi Mahi is offline
external usenet poster
 
Posts: 1
Default 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