Returning a cell reference

[thetoft]

Hello

I am trying to return a cell reference, but am having a lot of trouble. Has anyone got any ideas. I can get the cell value e.g. the contents of the cell but not the actual reference e.g. A1

 

[ssVBAdev]

ActiveCell.Row and ActiveCell.Column will return the Row and Colum numbers that you can use in your code.

 

[xlbo]

or activecell.address will return the address

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[Loomah]

and there's a little more, but not much, in this thread
thread68-569134

Happy Friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?