Get cell reference as parameter in function

  • Thread starter Thread starter RSunday
  • Start date Start date
R

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?
 
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.
 
Back
Top