Select active cell and return value

hi,

is this what you want?

rng = ActiveCell.Address

dave

That's it !!!!

I was using a variable as an integer and not a string.

.Address works a treat.

Thank you sweep !!

you're welcome - glad it works