View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_41_] Bill[_41_] is offline
external usenet poster
 
Posts: 2
Default 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