Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return cell co-ordinates
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return cell co-ordinates
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return cell co-ordinates
Hello Julie,
Try this: sub sayhi() dim st as string st = selection.address msgbox "you are in " & st end sub I just found this in a new book I bought the other day. TucsonBob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return cell co-ordinates
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return cell co-ordinates
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for x-y co-ordinates | Excel Discussion (Misc queries) | |||
sort X-Y co-ordinates | Excel Discussion (Misc queries) | |||
X-Y co-ordinates | Setting up and Configuration of Excel | |||
Co-ordinates | Excel Discussion (Misc queries) | |||
read co-ordinates | Charts and Charting in Excel |