Re: Named Range not recognised by VBA 2007
- From: "Charles Williams" <Charles@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 14 Oct 2007 14:54:52 +0100
Your Target named range looks like a formula rather than a range to me.
So you probably should be using Evaluate instead of Range
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
"Beertje" <Beertje@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A48E7E24-8CA5-4887-8E5D-4FB5F42DA35C@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Refer row or column of a range name
- Next by Date: Re: Check to see if Outlook is open Q
- Previous by thread: Refer row or column of a range name
- Next by thread: Re: Named Range not recognised by VBA 2007
- Index(es):
