Hello,
Is there a good way to search from the bottom of a spreadsheet? Also,
is it possible to search for more than one thing in a row? I want to
find a row based on it containing two different values in two different
cells.
Thanks,
Josh
Hello,
Is there a good way to search from the bottom of a spreadsheet? Also,
is it possible to search for more than one thing in a row? I want to
find a row based on it containing two different values in two different
cells.
Thanks,
Josh
You can search from the bottom up with VBA. For the other question, you can
use Data - Filter - Advanced Filter to find all instances of one row having
the two values you specify. Note that this procedure finds ALL instances,
not the last one or the first from the bottom. HTH Otto
"Josh" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> Is there a good way to search from the bottom of a spreadsheet? Also,
> is it possible to search for more than one thing in a row? I want to
> find a row based on it containing two different values in two different
> cells.
>
> Thanks,
> Josh
>
lastrow = cells(rows.count,1).End(xlup).row
for i = lastrow to 1 step -1
if cells(i,"B") = "House" and cells(i,"M") = "dog" then
end if
Next
--
Regards,
Tom Ogilvy
"Josh" wrote:
> Hello,
> Is there a good way to search from the bottom of a spreadsheet? Also,
> is it possible to search for more than one thing in a row? I want to
> find a row based on it containing two different values in two different
> cells.
>
> Thanks,
> Josh
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks