kiyiya
08-02-2008, 10:09 PM
How do I get a worksheet formula to work with VBA?
Example: =IF(C41=TRUE, INDEX(PriceList_Prices,MATCH(F41,PriceList,0)),"")
My project is using a lot of INDEX and MATCH combos to retrieve data from named ranges and I can't seem to get them to work with VBA.
I want to be be able to include them on a Userform.
Thanks.
Example: =IF(C41=TRUE, INDEX(PriceList_Prices,MATCH(F41,PriceList,0)),"")
My project is using a lot of INDEX and MATCH combos to retrieve data from named ranges and I can't seem to get them to work with VBA.
I want to be be able to include them on a Userform.
Thanks.