Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to use the method to create names for columns in "Myrange" with
the statement: Myrange.createnames Top:=True. It doesn't seem to execute properly. First, it won't execute until I answer the question "Do you want to redefine 'TDA'? TDA is the first entry in the second row first column, and I have to answer the question for each entry in the first column of every row. After I do that it executes and all the columns get named as expected, except the first column. The name for the first column appears in the name manager list but it is the original range less the first row and the first column--it is supposed to be just the first column. Also a lot of the first column entries end up in the name manager list and are names for their entire row. Does anyone have any experience with this method and know whether it works properly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Range Method | Excel Programming | |||
"PasteSpecial method of Range class failed" when range Number of Rows 2000 | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
Pass a range to a method? | Excel Programming |