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?

..Address will give the cell reference.

"RSunday" wrote:

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?

Public function RSunday(theRange as range)

.... =theRange.row

etc

--
Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"RSunday" wrote in message
...
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?

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.

"RSunday" wrote:

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?