#name in match

[WHOLEministries@gmail.com]

I am using vba in an automation routine.
As part of this, I have a column A full of dates.
"oneyear" is defined as a date.
"numberrows" is an integer that is determined earlier to identify the
number of rows in the range. It works.
I am using match because I want the row number identified.

Range("f2").Select
ActiveCell.FormulaR1C1 = "=match(oneyear,r[-1]c[-5]:r[" & numberrows -
2 & "]c[-5],1)"

After this code runs, I get a #Name? in F2.
I am not sure why. Any ideas would be appreciated.

TIA

[Bob Phillips]

That sounds like you don't really have a name called 'oneyear'. Check the
spelling of it again.

--

HTH

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


<WHOLEministries@gmail.com> wrote in message
news:1133894771.212181.169310@g44g2000cwa.googlegroups.com...
> I am using vba in an automation routine.
> As part of this, I have a column A full of dates.
> "oneyear" is defined as a date.
> "numberrows" is an integer that is determined earlier to identify the
> number of rows in the range. It works.
> I am using match because I want the row number identified.
>
> Range("f2").Select
> ActiveCell.FormulaR1C1 = "=match(oneyear,r[-1]c[-5]:r[" & numberrows -
> 2 & "]c[-5],1)"
>
> After this code runs, I get a #Name? in F2.
> I am not sure why. Any ideas would be appreciated.
>
> TIA
>

[Niek Otten]

You may have Dimmed the name in VBA, not defined in the spreadsheet
If so, get it outside the quotes

--
Kind regards,

Niek Otten

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OuO8xdp%23FHA.916@TK2MSFTNGP10.phx.gbl...
> That sounds like you don't really have a name called 'oneyear'. Check the
> spelling of it again.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <WHOLEministries@gmail.com> wrote in message
> news:1133894771.212181.169310@g44g2000cwa.googlegroups.com...
>> I am using vba in an automation routine.
>> As part of this, I have a column A full of dates.
>> "oneyear" is defined as a date.
>> "numberrows" is an integer that is determined earlier to identify the
>> number of rows in the range. It works.
>> I am using match because I want the row number identified.
>>
>> Range("f2").Select
>> ActiveCell.FormulaR1C1 = "=match(oneyear,r[-1]c[-5]:r[" & numberrows -
>> 2 & "]c[-5],1)"
>>
>> After this code runs, I get a #Name? in F2.
>> I am not sure why. Any ideas would be appreciated.
>>
>> TIA
>>
>
>

[Bob Phillips]

So many possible errors :-))

Bob


"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:%23e4GPop%23FHA.2812@TK2MSFTNGP09.phx.gbl...
> You may have Dimmed the name in VBA, not defined in the spreadsheet
> If so, get it outside the quotes
>
> --
> Kind regards,
>
> Niek Otten
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:OuO8xdp%23FHA.916@TK2MSFTNGP10.phx.gbl...
> > That sounds like you don't really have a name called 'oneyear'. Check
the
> > spelling of it again.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > <WHOLEministries@gmail.com> wrote in message
> > news:1133894771.212181.169310@g44g2000cwa.googlegroups.com...
> >> I am using vba in an automation routine.
> >> As part of this, I have a column A full of dates.
> >> "oneyear" is defined as a date.
> >> "numberrows" is an integer that is determined earlier to identify the
> >> number of rows in the range. It works.
> >> I am using match because I want the row number identified.
> >>
> >> Range("f2").Select
> >> ActiveCell.FormulaR1C1 = "=match(oneyear,r[-1]c[-5]:r[" & numberrows -
> >> 2 & "]c[-5],1)"
> >>
> >> After this code runs, I get a #Name? in F2.
> >> I am not sure why. Any ideas would be appreciated.
> >>
> >> TIA
> >>
> >
> >
>
>