Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to verify a cell is in a named range
I give up. I have been trying to figure this out but I can only get half of
it. I think I need "professional help"! I have a range name "TimeCells". I need to write an IF statement to verify that the activecell is within the bounds of the named range. Also I need to verify that I am on the correct worksheet. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to verify a cell is in a named range
One way:
Dim bSameSheet As Boolean Dim bInRange As Boolean With Range("TimeCells") bSameSheet = .Parent Is ActiveSheet If bSameSheet Then bInRange = _ Not Intersect(.Cells, ActiveCell) Is Nothing End With In article , "Terry Lowe" wrote: I give up. I have been trying to figure this out but I can only get half of it. I think I need "professional help"! I have a range name "TimeCells". I need to write an IF statement to verify that the activecell is within the bounds of the named range. Also I need to verify that I am on the correct worksheet. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
named cell range | Excel Worksheet Functions | |||
Getting a named range from a cell value | Excel Worksheet Functions | |||
Adding a named range to a cell | Excel Programming |