Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting row in macro
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting row in macro
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting row in macro
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with macro setting | Excel Discussion (Misc queries) | |||
macro picture setting | Excel Discussion (Misc queries) | |||
autofilter macro setting | Excel Worksheet Functions | |||
Setting borders with a macro | Excel Discussion (Misc queries) | |||
Setting up a Macro | Excel Worksheet Functions |