Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address
Hi
The question is: How to find if a specific cell has been selected and show its Column, Row and Address? Thank for your time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address
One way:
If ActiveCell.Address(False, False) = "A1" Then Msgbox "Column: " & ActiveCell.Column & vbNewLine & _ "Row: " & ActiveCell.Row & vbNewLine & _ "Address: " & ActiveCell.Address End If In article , "John Collins" wrote: Hi The question is: How to find if a specific cell has been selected and show its Column, Row and Address? Thank for your time. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address
If not intersect(Activecell, Range("A1:H100")) Then Msgbox ACtivecell.Address End If Untested, but should give some leads. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "John Collins" wrote in message ... Hi The question is: How to find if a specific cell has been selected and show its Column, Row and Address? Thank for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming |