Posted to microsoft.public.excel.programming

Scriptick

external usenet poster

Posts: 8

R1C1 riddle

Can anyone explain why the first line of code is 'skipping rows' and
the second and third are not? What am I missing?

Range("a1.b10").Formula = Array("=rc[1]", "=""Row: ""&ROW()")

Range("a1.b10").FormulaArray = Array("=rc[1]", "=""Row: ""&ROW()")
Range("c1.c10").Formula = "=""Row: ""&row(rc[1])"

Checked in Excel 2000 and Excel XP.

Regards,
Andre

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
XIRR and IRR riddle - Please Help!	kevwags	Excel Discussion (Misc queries)	1	February 9th 11 08:06 PM
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2	temp	Excel Discussion (Misc queries)	3	September 13th 07 08:31 AM
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2	temp	Excel Worksheet Functions	3	September 13th 07 08:31 AM
Help! I can't figure this riddle out	guyinatshirt	Excel Programming	5	November 20th 03 11:39 PM
r1c1	nath	Excel Programming	1	August 19th 03 03:51 PM

All times are GMT +1. The time now is 09:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us