Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Range.Name question
Excel XP & Win XP
I want to check if the ActiveCell range name is "Hello". I thought this little macro would work but it returns a "No". What is the correct way to make this check? Thanks for your help. Otto Sub TestName() If ActiveCell.Name = "Hello" Then MsgBox "Yes" Else MsgBox "No" End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range question | Excel Worksheet Functions | |||
Range Question | Excel Discussion (Misc queries) | |||
Range Question | Excel Discussion (Misc queries) | |||
Range question in '97 | Excel Discussion (Misc queries) | |||
Range.Formula and Range question using Excel Automation | Excel Programming |