Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Formular1c1

Anyone know why this won't work? Can I not mix R1c1 with a direct cell
reference like B1? And if not, How do I replace $B$3 with something in r1c1
format? Thanks!

Set colb = ActiveCell.Offset(0, -2)
colb.FormulaR1C1 = "=IF(RC[-1]=""Open"",MAX($B$3:R[-1]C[-2])+1,"""")"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FormulaR1C1	Aksel Børve	Excel Programming	2	February 28th 05 09:52 PM
activecell.formular1c1	monika	Excel Programming	0	April 29th 04 10:13 AM
FormulaR1C1	D.S.[_3_]	Excel Programming	2	January 2nd 04 12:03 AM
FormulaR1C1	D.S.[_3_]	Excel Programming	0	January 1st 04 09:12 PM
FormulaR1C1	aapp81[_22_]	Excel Programming	3	December 3rd 03 10:47 PM

All times are GMT +1. The time now is 10:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us