B
Beertje
Created (name Manager) one dynamic range, named: PerfM, a list of 34 Months
and growing each month:
Code:
PerfM=OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A:$A),1)
Created (name Manager) a second dynamic range, named: Target, a list as long
as PerfM filled with the same number, let's say 6:
Code:
Target=6*ROW(PerfM)/ROW(PerfM)
Target is filled with 1 column and 34 rows value 6. My problem is that VBA
does not recognize Target as a range:
Code:
Set myarray = Range("PerfM")
is recognized, but
Code:
Set myarray = Range("Target")
is not recognized. Run-time eroor 1004. Method of "Range" object'_Global'
failed.
Both names have global scope, and are defined in VBA as Public.
Any clues?
and growing each month:
Code:
PerfM=OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A:$A),1)
Created (name Manager) a second dynamic range, named: Target, a list as long
as PerfM filled with the same number, let's say 6:
Code:
Target=6*ROW(PerfM)/ROW(PerfM)
Target is filled with 1 column and 34 rows value 6. My problem is that VBA
does not recognize Target as a range:
Code:
Set myarray = Range("PerfM")
is recognized, but
Code:
Set myarray = Range("Target")
is not recognized. Run-time eroor 1004. Method of "Range" object'_Global'
failed.
Both names have global scope, and are defined in VBA as Public.
Any clues?