I'm trying to create a MATCH formula in VBA, set it in one cell of "Sheet2", and then fill it down a column. The formula will be set in B6, and the Lookup_Value is in C6. The Lookup_Array is 'Sheet1'!A6:A200 - the range A6:A200 in "Sheet1", where "Sheet1" is the text in cell A6 in Sheet2 (where the formula will be set).
The problem I'm running into how to reference Sheet2!A6 in the formula to get the name of Sheet1, so when I fill down the formula, Sheet2!A6 will increment (Sheet2!A7 .... A8 .... etc) and return the cell value, which is the Sheet1 name for the formula.
(I hope that makes sense!!)
Ed
The problem I'm running into how to reference Sheet2!A6 in the formula to get the name of Sheet1, so when I fill down the formula, Sheet2!A6 will increment (Sheet2!A7 .... A8 .... etc) and return the cell value, which is the Sheet1 name for the formula.
(I hope that makes sense!!)
Ed