Column of a defined name (office 2000 vs XP)?

Hi,

this works in office XP

vAddress =
Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
vCol = Range(vAddress).Column

but not in office 2000. There must be an incompatibility, I guess.

How can I know the column-number of a named range in Office 2000?

Thanks
Jos Vens

How about

Workbooks(sParameters.Parent.Name).Range(vName).Column

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jos Vens" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> this works in office XP
>
> vAddress =
> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
> vCol = Range(vAddress).Column
>
> but not in office 2000. There must be an incompatibility, I guess.
>
> How can I know the column-number of a named range in Office 2000?
>
> Thanks
> Jos Vens
>
>

Thanks a lot Bob,

it works (and is much simpler)!

Jos


"Bob Phillips" <[email protected]> schreef in bericht
news:%[email protected]...
> How about
>
> Workbooks(sParameters.Parent.Name).Range(vName).Column
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jos Vens" <[email protected]> wrote in message
> news:[email protected]...
>> Hi,
>>
>> this works in office XP
>>
>> vAddress =
>> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
>> vCol = Range(vAddress).Column
>>
>> but not in office 2000. There must be an incompatibility, I guess.
>>
>> How can I know the column-number of a named range in Office 2000?
>>
>> Thanks
>> Jos Vens
>>
>>
>
>

Hi Bob,

small correction

sParameters.Range(vName).Column

where sParameters is a pointer to a sheet. With workbooks, it does not
work!


Jos


"Bob Phillips" <[email protected]> schreef in bericht
news:%[email protected]...
> How about
>
> Workbooks(sParameters.Parent.Name).Range(vName).Column
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jos Vens" <[email protected]> wrote in message
> news:[email protected]...
>> Hi,
>>
>> this works in office XP
>>
>> vAddress =
>> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
>> vCol = Range(vAddress).Column
>>
>> but not in office 2000. There must be an incompatibility, I guess.
>>
>> How can I know the column-number of a named range in Office 2000?
>>
>> Thanks
>> Jos Vens
>>
>>
>
>

Hi Jos,

So how did this ever work inn XP?

vAddress =
Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
vCol = Range(vAddress).Column


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jos Vens" <[email protected]> wrote in message
news:[email protected]...
> Hi Bob,
>
> small correction
>
> sParameters.Range(vName).Column
>
> where sParameters is a pointer to a sheet. With workbooks, it does not
> work!
>
>
> Jos
>
>
> "Bob Phillips" <[email protected]> schreef in bericht
> news:%[email protected]...
> > How about
> >
> > Workbooks(sParameters.Parent.Name).Range(vName).Column
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Jos Vens" <[email protected]> wrote in message
> > news:[email protected]...
> >> Hi,
> >>
> >> this works in office XP
> >>
> >> vAddress =
> >> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
> >> vCol = Range(vAddress).Column
> >>
> >> but not in office 2000. There must be an incompatibility, I guess.
> >>
> >> How can I know the column-number of a named range in Office 2000?
> >>
> >> Thanks
> >> Jos Vens
> >>
> >>
> >
> >
>
>

Hi Bob,

it worked!

I guess because the RefersTo gives a string, and the Range of a
string-address has a property column in XP?

It's the "vCol = Range(vAddress).Column" that gave an error in Office 2000,
but the on error resume next set up a trap for me, I thougt it worked.

Jos

"Bob Phillips" <[email protected]> schreef in bericht
news:%[email protected]...
> Hi Jos,
>
> So how did this ever work inn XP?
>
> vAddress =
> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
> vCol = Range(vAddress).Column
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jos Vens" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Bob,
>>
>> small correction
>>
>> sParameters.Range(vName).Column
>>
>> where sParameters is a pointer to a sheet. With workbooks, it does not
>> work!
>>
>>
>> Jos
>>
>>
>> "Bob Phillips" <[email protected]> schreef in bericht
>> news:%[email protected]...
>> > How about
>> >
>> > Workbooks(sParameters.Parent.Name).Range(vName).Column
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "Jos Vens" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Hi,
>> >>
>> >> this works in office XP
>> >>
>> >> vAddress =
>> >> Workbooks(sParameters.Parent.Name).Names(vName).RefersTo
>> >> vCol = Range(vAddress).Column
>> >>
>> >> but not in office 2000. There must be an incompatibility, I guess.
>> >>
>> >> How can I know the column-number of a named range in Office 2000?
>> >>
>> >> Thanks
>> >> Jos Vens
>> >>
>> >>
>> >
>> >
>>
>>
>
>