# NAME

[samp]

fill a spreadsheet from this access point

Plan.Range("F" & l).FormulaR1C1 = "=SUM(R[-9]C:R[-2]C)"



the time signature and passed to the spreadsheet and will put is
correct as # NAME? if you self direct sum in excel works already
checked the correct format ta everything someone already went through
this?

 

[Arvin Meyer [MVP]]

This is an Excel question as:

Plan.Range("F" & l).FormulaR1C1 = "=SUM(R[-9]C:R[-2]C)"

is not being recognized by Excel.

 

[samp]

press F2 works

 

[samp]

access question

 

[John W. Vinson]

access question

If you have an Access question, please feel free to ask it. Use the big
textbox. And remember that you're talking to human volunteers, not to
Microsoft nor to a search engine.