If Not Intersect(Target,Range("CategoriesList")) Is Nothing Then
'do your thing

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

Is it possible to test if the active cell is within a certain range?

I have a short list of categories, A36:A47, that I have given the range
the name "CategoriesList". In the
"Worksheet_SelectionChange" event, I want to test to see if the new active
cell is within the CategoriesList range and if it is, set
another cell on the worksheet to the same value as the active cell.

If it is possible, please provide sample code.

--
Thanks for any help anyone can provide,

Conan Kelly