Minimum qualifiers to Find (VBA) the actual last used Row, Column

2003

Have played with the following VBA code arguments but all seem to give
same result whether included or excluded:

Cells.Find( _
What:="*", _
after:=ActiveSheet.Cells(1, 1), _
LookIn:=xlFormulas, _
lookat:=xlWhole, _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByRows) _
.Row

What is the minimum set of arguements to always fine the last used row?


Why does not appear to make any difference to the end result, if I
include or exclude the following - what am I missing?
after:=ActiveSheet.Cells(1, 1), _
LookIn:=xlFormulas, _
lookat:=xlWhole, _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByRows) _
.Row

Thanks, EagleOne

Excel and VBA work together with .Find. They each remember the parameters in
the previous Find (either manually or via code).

Because of this, your testing is just testing the last set of parms that were
used. And that's one very good reason to specify all the parms you want--if you
don't specify them, then you'll be trusting that the last Find that was done
used the same parms as the ones you want.



EagleOne wrote:
>
> 2003
>
> Have played with the following VBA code arguments but all seem to give
> same result whether included or excluded:
>
> Cells.Find( _
> What:="*", _
> after:=ActiveSheet.Cells(1, 1), _
> LookIn:=xlFormulas, _
> lookat:=xlWhole, _
> SearchDirection:=xlPrevious, _
> SearchOrder:=xlByRows) _
> .Row
>
> What is the minimum set of arguements to always fine the last used row?
>
> Why does not appear to make any difference to the end result, if I
> include or exclude the following - what am I missing?
> after:=ActiveSheet.Cells(1, 1), _
> LookIn:=xlFormulas, _
> lookat:=xlWhole, _
> SearchDirection:=xlPrevious, _
> SearchOrder:=xlByRows) _
> .Row
>
> Thanks, EagleOne

--

Dave Peterson

Very interesting!

Dave, what other Excel/VBA functions "remember" previous settings?

EagleOne


Dave Peterson wrote:
> Excel and VBA work together with .Find. They each remember the parameters in
> the previous Find (either manually or via code).
>
> Because of this, your testing is just testing the last set of parms that were
> used. And that's one very good reason to specify all the parms you want--if you
> don't specify them, then you'll be trusting that the last Find that was done
> used the same parms as the ones you want.
>
>
>
> EagleOne wrote:
> >
> > 2003
> >
> > Have played with the following VBA code arguments but all seem to give
> > same result whether included or excluded:
> >
> > Cells.Find( _
> > What:="*", _
> > after:=ActiveSheet.Cells(1, 1), _
> > LookIn:=xlFormulas, _
> > lookat:=xlWhole, _
> > SearchDirection:=xlPrevious, _
> > SearchOrder:=xlByRows) _
> > .Row
> >
> > What is the minimum set of arguements to always fine the last used row?
> >
> > Why does not appear to make any difference to the end result, if I
> > include or exclude the following - what am I missing?
> > after:=ActiveSheet.Cells(1, 1), _
> > LookIn:=xlFormulas, _
> > lookat:=xlWhole, _
> > SearchDirection:=xlPrevious, _
> > SearchOrder:=xlByRows) _
> > .Row
> >
> > Thanks, EagleOne
>
> --
>
> Dave Peterson

I don't know.

I do know that data|text to columns tries to help when you do it one time, then
paste from a different application.

EagleOne wrote:
>
> Very interesting!
>
> Dave, what other Excel/VBA functions "remember" previous settings?
>
> EagleOne
>
> Dave Peterson wrote:
> > Excel and VBA work together with .Find. They each remember the parameters in
> > the previous Find (either manually or via code).
> >
> > Because of this, your testing is just testing the last set of parms that were
> > used. And that's one very good reason to specify all the parms you want--if you
> > don't specify them, then you'll be trusting that the last Find that was done
> > used the same parms as the ones you want.
> >
> >
> >
> > EagleOne wrote:
> > >
> > > 2003
> > >
> > > Have played with the following VBA code arguments but all seem to give
> > > same result whether included or excluded:
> > >
> > > Cells.Find( _
> > > What:="*", _
> > > after:=ActiveSheet.Cells(1, 1), _
> > > LookIn:=xlFormulas, _
> > > lookat:=xlWhole, _
> > > SearchDirection:=xlPrevious, _
> > > SearchOrder:=xlByRows) _
> > > .Row
> > >
> > > What is the minimum set of arguements to always fine the last used row?
> > >
> > > Why does not appear to make any difference to the end result, if I
> > > include or exclude the following - what am I missing?
> > > after:=ActiveSheet.Cells(1, 1), _
> > > LookIn:=xlFormulas, _
> > > lookat:=xlWhole, _
> > > SearchDirection:=xlPrevious, _
> > > SearchOrder:=xlByRows) _
> > > .Row
> > >
> > > Thanks, EagleOne
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson