refering to a variable in a cell.formula
Sometime I have to use a temporary variable to get it to work. It is also
easier to debug problems doing it this way.
temp = "=MATCH(" & ActiveSheet.Cells(1 ,"B") & ",'Brand list'!B$1:B$1861, 0)"
ActiveSheet.Cells(i ,9).Formula = temp
"cw" wrote:
Nice
Giving it a go now
thanks
"Joel" wrote in message
...
ActiveSheet.Cells(i ,9).Formula = "=MATCH(" & _
ActiveSheet.Cells(1 ,"B") & ",'Brand list'!B$1:B$1861, 0)"
"cw" wrote:
Hi All
I just have a quick question, is it possible to refer to a variable in
the
formula below
where B1 is after MATCH, I want that to match the variable 'i' in the
Cells.(i,9)
ActiveSheet.Cells(i ,9).Formula = "=MATCH(B1,'Brand list'!B$1:B$1861, 0)"
Thanks
Craig
|