Get cell reference as parameter in function

[RSunday]

I want to give a cell as a parameter to a function. In the function I want to
use the built-in functions ROW and COLUMN on the cell - i.e. I dont want the
value in the cell but the actual "cell reference".

How do I define my parameter for that use?

 

[JLGWhiz]

..Address will give the cell reference.

 

[Charles Williams]

Public function RSunday(theRange as range)

.... =theRange.row

etc

 

[JLGWhiz]

You could probably get better suggestions if you post the code you are trying
to work with. To create a cell reference in the Cells(x, y) format requires
using an anchor reference that VBA already recognizes. Without seeing your
code, it is difficult to give you a viable solution short of a tutorial on
using variables to assign cell references.