Get Address & Worksheet Name Of Cells

way to transform the commun Excel VBA reference to a cell

Cells(a,b)

to the reference inside a cell, like

"A1"

.

The idea behind is to introduce an Excel formula in a cell, with a reference to another cell. Thus, in my macro, the reference is

Cells(a,b)

, and in the formula string, the reference must be the form "A1".

I now I can programm a function for it, but before I would like to know if there isn't a easier way like an integrate Excel function to do it faster and better.