Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to determine at runtime whether the selected cell has a range
name, and what that name is. This is to error trap the user accidentally selecting a row that is a category header (column A of these rows are named) as opposed to a row containing content (column A not named). If I use Range("A" & intRow).Name it shows "=Sheet!$A$13" instead of the name I'm looking for Any help appreciated. Bill Le May |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining Range of selected cell | Excel Programming | |||
Referencing the First Cell in Any Selected Range | Excel Programming | |||
Macro run if and cell in range is selected in VBA | Excel Programming | |||
Macro run if and cell in range is selected in VBA | Excel Programming | |||
Activate last cell in selected range - an example | Excel Programming |