Problem with Lookup-function

[SamMy]

Sub test()
Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
Cells(4, 3).Value = "LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Succees
Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Error
End Sub

VBA in Excel 2002. Two first lines succees, but the third one gives error
'Runtime error 1004: Application or object defined error'. What's wrong with
the third row?

[Bob Phillips]

The second only works because you have an error, no leadiung = <vbg>

Sub test()
Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
Cells(4, 3).Value = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)" 'Succees
Cells(2, 3).FormulaR1C1 = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)" 'Error
End Sub



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SamMy" <[email protected]> wrote in message
news:[email protected]...
> Sub test()
> Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
> Cells(4, 3).Value = "LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Succees
> Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Error
> End Sub
>
> VBA in Excel 2002. Two first lines succees, but the third one gives error
> 'Runtime error 1004: Application or object defined error'. What's wrong
with
> the third row?

[SamMy]

Could you be more specific? No leading - what?

"Bob Phillips" kirjoitti:

> The second only works because you have an error, no leadiung = <vbg>
>
> Sub test()
> Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
> Cells(4, 3).Value = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)" 'Succees
> Cells(2, 3).FormulaR1C1 = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)" 'Error
> End Sub
>
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "SamMy" <[email protected]> wrote in message
> news:[email protected]...
> > Sub test()
> > Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
> > Cells(4, 3).Value = "LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Succees
> > Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Error
> > End Sub
> >
> > VBA in Excel 2002. Two first lines succees, but the third one gives error
> > 'Runtime error 1004: Application or object defined error'. What's wrong
> with
> > the third row?
>
>
>

[Bob Phillips]

I did, no leading =.

I also gave you corrected code. As I understand, in VBA you use commas
regardless of your settings, Excel will transform it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SamMy" <[email protected]> wrote in message
news:[email protected]...
> Could you be more specific? No leading - what?
>
> "Bob Phillips" kirjoitti:
>
> > The second only works because you have an error, no leadiung = <vbg>
> >
> > Sub test()
> > Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
> > Cells(4, 3).Value = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)"
'Succees
> > Cells(2, 3).FormulaR1C1 = "=LOOKUP(3,R1C2:R5C2,R1C1:R5C1)" 'Error
> > End Sub
> >
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "SamMy" <[email protected]> wrote in message
> > news:[email protected]...
> > > Sub test()
> > > Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)"
'Succees
> > > Cells(4, 3).Value = "LOOKUP(3;R1C2:R5C2;R1C1:R5C1)"
'Succees
> > > Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Error
> > > End Sub
> > >
> > > VBA in Excel 2002. Two first lines succees, but the third one gives
error
> > > 'Runtime error 1004: Application or object defined error'. What's
wrong
> > with
> > > the third row?
> >
> >
> >

[SamMy]

Now I got it (thank god it's friday ).

Thank You!

[Bob Phillips]

No argument the <G>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SamMy" <[email protected]> wrote in message
news:[email protected]...
> Now I got it (thank god it's friday ).
>
> Thank You!