| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check the name of a cell
Im trying to check the cell below the active cell to see if it has a name or
not. I tried If ActiveCell.offset(1, 0).Name.Name = "" Then but it doent like that. Any suggestions? PS sorry if this posts twice, Im not sure if it went through the first time. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check the name of a cell
If the cell in question does not have a name you get an error. So you have
to trap that error using On Error. -- Jim "Kevin" wrote in message ... | Im trying to check the cell below the active cell to see if it has a name or | not. | I tried | If ActiveCell.offset(1, 0).Name.Name = "" Then | but it doent like that. Any suggestions? | | PS sorry if this posts twice, Im not sure if it went through the first time. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check the name of a cell
hmm, cool I can work with that. I did this...
If ActiveCell.offset(1, 0).Name.Name < "" Then Thanks a bunch for the help, this forum is great! "Jim Rech" wrote: If the cell in question does not have a name you get an error. So you have to trap that error using On Error. -- Jim "Kevin" wrote in message ... | Im trying to check the cell below the active cell to see if it has a name or | not. | I tried | If ActiveCell.offset(1, 0).Name.Name = "" Then | but it doent like that. Any suggestions? | | PS sorry if this posts twice, Im not sure if it went through the first time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Cannot check the check mark box in cell | Excel Worksheet Functions | |||
| check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Hybrid Mode
