passing cell address to function

I'm not a newbie to programming but for some reasons I can't find a straight forward answer to my question.

How do I pass an address (in the form of 1,1 or 2,5) of an active cell to a function in excel 2007 vba? How would I declare this in a function?

david90,

You can use the following as an example to help get you started:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar