Hi Dave

thanks for this, didn't know how to do it ..

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Dave Peterson" wrote in message
...
Just to add to Julie's response:

You may want:

sub sayhi()
msgbox "you are in " & activecell.address(false,false)
end sub

This removes the $'s from $A$4.



JulieD wrote:

Hi Jonny

sub sayhi()
msgbox "you are in " & activecell.address
end sub

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Jonny" wrote in message
...
Hi I haven't used vba for a while now and i've completely forgotten how
to
return a cells range.

All i need is a simple msgbox that says "you are in cell A4"

Very easy i know, but the grey matter can't cope

TIA

--

Dave Peterson