here's what my problem is...

when I use this function in my macro I would like to modify the value
that is set to -R[-10]


"=INDEX([Master.xls]defenition!R6C1:R80C5,
MATCH([Master.xls]Master!R[-10]C[28],[Master.xls]defenition!R6C1:R80C1,),
MATCH(R12C4,[Master.xls]defenition!R6C1:R6C5,))"


I need to make it dynamic.... I change the range everytime it goes in
my FOR loop. I tried doing this R[-(10 + counter)] but it didn't like
that very much :)
what is the syntax that I need to use in order to be able to add on
every pass of the for loop???



thanks

PAbs


---
Message posted from http://www.ExcelForum.com/