M
Miree
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
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