Mykasd
03-06-2008, 11:27 AM
This is similar to my last post, but this is what i'm trying
current:
ActiveWorkbook.Names.Add Name:="UniqueDMs", RefersToR1C1:= _
"=Dashboard!R2C53:R21C53"
want it to read something like this (modified for changing values of DMCount):
ActiveWorkbook.Names.Add Name:="UniqueDMs", RefersToR1C1:= _
"=Dashboard!R2C53:R & DMCount C53"
It needs to vary according to what value DMCount has. The reason is I am trying to populate a user form list with the Range UniqueDMs which changes according to the DMCount...
current:
ActiveWorkbook.Names.Add Name:="UniqueDMs", RefersToR1C1:= _
"=Dashboard!R2C53:R21C53"
want it to read something like this (modified for changing values of DMCount):
ActiveWorkbook.Names.Add Name:="UniqueDMs", RefersToR1C1:= _
"=Dashboard!R2C53:R & DMCount C53"
It needs to vary according to what value DMCount has. The reason is I am trying to populate a user form list with the Range UniqueDMs which changes according to the DMCount...