ExcelBanter - Test if Active Cell is in a named range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Test if Active Cell is in a named range (https://www.excelbanter.com/excel-programming/311639-test-if-active-cell-named-range.html)

Simon Shaw[_5_]

Test if Active Cell is in a named range

How can I validate is the active cell is within a named range?

Bob Phillips[_6_]

Test if Active Cell is in a named range

If Not Intersect(Activecell,Range("myRange")) Is Nothing Then

--

HTH

RP

"Simon Shaw" wrote in message
...
How can I validate is the active cell is within a named range?

All times are GMT +1. The time now is 01:06 AM.