MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I don't know

Posted by amroo on June 26, 2001 1:13 AM

Bonjour, I don't know the right syntaxe for this code line (the second part from SUM ....:
Dim numline
numline= =cells.find("100").row
Range("B" & numline).FormulaR1C1 = "=SUM(R[-numline]C:R[-1]C)"
or this syntaxe SUM(B2:B & numline)
Help is greatly appreciate.

Posted by Aladin Akyurek on June 26, 2001 1:42 AM

Yes, you do :)

Put some numbers in the range that you want to sum in ordinary style.

Say: =SUM(A1:A6)

Now switch to the R1C1 style on the General tab via Edit|Preferences (on the Mac) or via Toools|Options on Windows.

Look at the formula you typed before the switch. Make a note of it. Then switch back.

Wouldn't that help?


Posted by Aladin Akyurek on June 26, 2001 2:29 AM

and see: (NT)