Hi
Give this a try:
MsgBox Range("array").Resize(3).Address
ActiveWorkbook.Names.Add Name:="array", RefersToR1C1:=Range("array").Resize(3)
Can you show us your code please?
When you say you have a cell named "array" - do you mean a workbook level named range? If so this should work:
Code:ActiveWorkbook.Names.Add Name:="array", RefersToR1C1:=Range("array").Resize(3)
Note, this will increase the size of the array by two rows each time the macro is run.
should work.Code:Range("A1:A3").Name = "blah"