References in VBA

[Floyd]

If I have a function such as TestFxn(A1, A3), how do I get the exact
reference and not the cell value into the function?

Function TextFxn(A1, A3)
Debug.Print A1
End Function

Immediate Window:
A1 or "A1" of "$A$1" etc

Thanks in advance.

 

[Fredrik Wahlgren]

If I have a function such as TestFxn(A1, A3), how do I get the exact
reference and not the cell value into the function?

Function TextFxn(A1, A3)
Debug.Print A1
End Function

Immediate Window:
A1 or "A1" of "$A$1" etc

Thanks in advance.

One way is to pass the parameters as Range rather than String, long or
whatever. So if TextFxn is declared like this
Public TextFxn(r1 As Range, r2 As Range) As long
you get the reference from r1.Address

/Fredrik

 

[Floyd]

Frederik,

Thank you.

Now, I am off and running once again.

Cheers.