Change y.address to
y.address(1,1,xlA1,True)

--
Regards,
Tom Ogilvy



"pm" wrote in message ...
pm wrote:

s = "=INDEX('" & c & x & "'!C8:EX8,1,MATCH(" & y.Address & ",'" & c
& x & "'!C15:EX15,0))"

y.Address


everything seems to be ok, only when i work in the same sheet..

ie. i use my function in D20 cell in sheet1 and then in another sheet i'd
like to
get value from this cell (by simple link) =Sheet!D4 and i get #N/D!

just i write anything in another sheet and results in D20 in sheet1 turn
into error,
when i write anything in sheet1 result in D20 become value...

does this function work only when i operate in sheet i placed this
function?

rgs