Hi All,
I'd like to understand the difference between these two syntaxes below:

a./ lastcolumn = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Column
This one works!

b./ lastcolumn = Cells.Find("*", Range("A1"), xlPart,
xlValues, xlByColumns, xlPrevious, False).Column

This one does not work at the same place in the code, but gives an error
message No. 1004 saying Find property of Class range not accessible!

Regards,
Stefi

That is because in the first example you have the Find arguments out of
order, LookIn comes before LookAt in the order. By specifying the keywords
that doesn't matter, but when you don't specify them you need to be in the
correct order.

So

lastcolumn = Cells.Find("*", Range("A1"), xlValues, xlPart,
xlByColumns, xlPrevious, False).Column

should work

--
HTH

Bob Phillips

"Stefi" wrote in message
...
Hi All,
I'd like to understand the difference between these two syntaxes below:

a./ lastcolumn = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Column
This one works!

b./ lastcolumn = Cells.Find("*", Range("A1"), xlPart,
xlValues, xlByColumns, xlPrevious, False).Column

This one does not work at the same place in the code, but gives an error
message No. 1004 saying Find property of Class range not accessible!

Regards,
Stefi

Thanks, Bob, how obvious the answer and how difficult to notice the
difference for an unpracticed eye.
Stefi


€žBob Phillips€� ezt Ã*rta:

That is because in the first example you have the Find arguments out of
order, LookIn comes before LookAt in the order. By specifying the keywords
that doesn't matter, but when you don't specify them you need to be in the
correct order.

So

lastcolumn = Cells.Find("*", Range("A1"), xlValues, xlPart,
xlByColumns, xlPrevious, False).Column

should work

--
HTH

Bob Phillips

"Stefi" wrote in message
...
Hi All,
I'd like to understand the difference between these two syntaxes below:

a./ lastcolumn = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Column
This one works!

b./ lastcolumn = Cells.Find("*", Range("A1"), xlPart,
xlValues, xlByColumns, xlPrevious, False).Column

This one does not work at the same place in the code, but gives an error
message No. 1004 saying Find property of Class range not accessible!

Regards,
Stefi

That's why its good programming practice to use named arguments.
Sure, its a bit more typing, but it saves you from errors in
calling methods.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Stefi" wrote in message
...
Thanks, Bob, how obvious the answer and how difficult to notice
the
difference for an unpracticed eye.
Stefi


"Bob Phillips" ezt írta:

That is because in the first example you have the Find
arguments out of
order, LookIn comes before LookAt in the order. By specifying
the keywords
that doesn't matter, but when you don't specify them you need
to be in the
correct order.

So

lastcolumn = Cells.Find("*", Range("A1"),
xlValues, xlPart,
xlByColumns, xlPrevious, False).Column

should work

--
HTH

Bob Phillips

"Stefi" wrote in message
...
Hi All,
I'd like to understand the difference between these two
syntaxes below:

a./ lastcolumn = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Column
This one works!

b./ lastcolumn = Cells.Find("*", Range("A1"),
xlPart,
xlValues, xlByColumns, xlPrevious, False).Column

This one does not work at the same place in the code, but
gives an error
message No. 1004 saying Find property of Class range not
accessible!

Regards,
Stefi

Yes, you are right, one can avoid errors by using named arguments, but I
learned what rules are to be kept to when using different syntaxes from my
own fault (and from Bob's answer of course).

Nonetheless I keep your advice in mind.
Regards,
Stefi


€žChip Pearson€� ezt Ã*rta:

That's why its good programming practice to use named arguments.
Sure, its a bit more typing, but it saves you from errors in
calling methods.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Stefi" wrote in message
...
Thanks, Bob, how obvious the answer and how difficult to notice
the
difference for an unpracticed eye.
Stefi


"Bob Phillips" ezt Ã*rta:

That is because in the first example you have the Find
arguments out of
order, LookIn comes before LookAt in the order. By specifying
the keywords
that doesn't matter, but when you don't specify them you need
to be in the
correct order.

So

lastcolumn = Cells.Find("*", Range("A1"),
xlValues, xlPart,
xlByColumns, xlPrevious, False).Column

should work

--
HTH

Bob Phillips

"Stefi" wrote in message
...
Hi All,
I'd like to understand the difference between these two
syntaxes below:

a./ lastcolumn = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Column
This one works!

b./ lastcolumn = Cells.Find("*", Range("A1"),
xlPart,
xlValues, xlByColumns, xlPrevious, False).Column

This one does not work at the same place in the code, but
gives an error
message No. 1004 saying Find property of Class range not
accessible!

Regards,
Stefi