Posted to microsoft.public.excel.programming

L. Howard

external usenet poster

Posts: 852

Write to intersect of a row and column

MATCH returns the column number refering to the range. For the correct
column number you have to start in A and 1 or you have to add the
offset:
myAddr = Evaluate("Address(MATCH(C1,A1:A9,0),MATCH(E1,A3:I3 ,0))")
or
myAddr = Evaluate("Address(MATCH(C1,A4:A9,0)+3,MATCH(E1,B3: I3,0)+1)")

Regards
Claus B.

Thanks Claus. Clears that up, and seems to be working just fine.

Howard

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
ActiveCell.Row & Column intersect	[email protected]	Excel Programming	2	March 2nd 07 05:08 PM
Select cell where column and row intersect.	[email protected]	Excel Programming	6	December 3rd 06 08:01 PM
Row column intersect	thiaga	Excel Programming	0	April 4th 06 06:32 PM
find a specific value in a column and write another column	MUSTANG	Excel Discussion (Misc queries)	2	February 5th 06 09:24 AM
How do I find where a column value and row value intersect?	Amy	Excel Worksheet Functions	2	January 12th 05 11:19 PM

All times are GMT +1. The time now is 08:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us