Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refers to active cell not working
I had this code
ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:="=Densities!R4C6:R139C6" But needed it to refer to the active cells for that i did ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:=Selection.Address Which seemed to work fine BUT it only names the cell range, and not the work book so i cant use the defined range anywhere else I have tried MyList = Selection.Address ActiveWorkbook.Names.Add Name:="OBM", RefersTo:="=Densities!" & MyList but this still only uses the cell range and not the work book Please Help me Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refers to active cell not working
Hi
You only create a named list which refer to a specific sheet. A named range can not refer to another workbook. HTH Per "Miree" skrev i meddelelsen ... I had this code ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:="=Densities!R4C6:R139C6" But needed it to refer to the active cells for that i did ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:=Selection.Address Which seemed to work fine BUT it only names the cell range, and not the work book so i cant use the defined range anywhere else I have tried MyList = Selection.Address ActiveWorkbook.Names.Add Name:="OBM", RefersTo:="=Densities!" & MyList but this still only uses the cell range and not the work book Please Help me Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refers to active cell not working
I have a work book that works on one sheet i have all of the list data
On another sheet where i need the data, the cells have the validation =INDIRECT($F$8) which refers to the list names. It works in the book i have. Sorry my english was wrong in my initial question ment to say it only references the cell range not the worksheet.(not work book) "Per Jessen" wrote: Hi You only create a named list which refer to a specific sheet. A named range can not refer to another workbook. HTH Per "Miree" skrev i meddelelsen ... I had this code ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:="=Densities!R4C6:R139C6" But needed it to refer to the active cells for that i did ActiveWorkbook.Names.Add Name:="OBM", RefersToR1C1:=Selection.Address Which seemed to work fine BUT it only names the cell range, and not the work book so i cant use the defined range anywhere else I have tried MyList = Selection.Address ActiveWorkbook.Names.Add Name:="OBM", RefersTo:="=Densities!" & MyList but this still only uses the cell range and not the work book Please Help me Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refers to active cells | Excel Programming | |||
macro than refers to a cell? | Excel Discussion (Misc queries) | |||
API to find position of active cell no longer working in 2007. | Excel Programming | |||
Cell has a value of #N/A when the formula refers to nothing | Excel Programming | |||
Macro execution refers not to the active sheet/excel file | Excel Programming |