G
Guest
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
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