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/

Hi pabs, if you would like to a variable in the formula written in VBA
the variable part shoud be divided by a double quote and ampersand a
follows.


Code
-------------------


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


-------------------


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

ahh,...that's what I was missing! thanks

Pabs


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