Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
names and deleting them
I am running a code that is trying to clear out the names that are being
copied over from one workbook to another.... i tried to do this... Private sub whateveritiscalled() dim n as name dim wkb as workbook set wkb = workbooks.add thisworkworkbook.activesheet.cells.copy wkb.activesheet.range("a1").paste 'actually it is pastespecial...not important for each n in wkb.names n.delete next etc...etc...etc.. however, it keeps getting an error on the n.delete statement...run time error 1004...must be missing something....can anyone help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting of names | Excel Programming | |||
deleting names from the name box | Excel Discussion (Misc queries) | |||
deleting duplicate names | Excel Worksheet Functions | |||
Deleting Names | Excel Programming | |||
Deleting workbook names w/ VB | Excel Programming |