Creating function

[Alpacino]

How would you write this formula to create Function in vba
=Address(match(A11,A1:A7,0),(match(B11,A1:E1,0))
Any ideas
Thanks in advance

 

[jim may]

Not sure I'm understanding exactly what you want but you can enter your formula
directly into a cell by running the Macro (I've currently chose the Activecell, you could change to say Range("G1").formula


Sub Foo()
ActiveCell.Formula = "=ADDRESS(MATCH(A11,A1:A7,0),MATCH(B11,A1:E1,0))"
End Sub

 

[Alpacino]

Doesnt seem to work I am using Excel 2003 does that make a difference