Does the selected cell have a range name?
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
|