Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know if cell has name
How can I test a cell for a Name, "activecell.name".
In my code below, it will generate an error if a cell is clicked that has no ".Name". (Option Explicit assumed) '====== Sub x() 'Begin Registry setting 'Notes: '100% active on all cells clicked sSpecLastWs = ActiveSheet.Name SaveSetting appname:="ADM_Spec_Index", section:="WorkSheetNames", _ Key:="sSpecLastWs", setting:=sSpecLastWs sSpecLastCell = ActiveCell.Name 'FAILS HERE SaveSetting appname:="ADM_Spec_Index", section:="WorkSheetNames", _ Key:="sSpecLastCell", setting:=sSpecLastCell 'End Registry setting End Sub '====== -- Regards VBA.Newb.Confused XP Pro Office 2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |