BOBODD
12/14/2006 12:56:00 AM
Wow! Thanks guys, that's a fair amount of info to go on with.
"Don Guillett" wrote:
> or to look in the first column
>
> Sub dd()
> Range("BankAccounts").Columns(1).Find("").Select
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "BOBODD" <BOBODD@discussions.microsoft.com> wrote in message
> news:B54BEB6E-481F-4670-BAD5-F57F3D8771CB@microsoft.com...
> >I have a named range "BankAccounts" which is A12:A52. This range fills from
> > A12 down. I'm using
> >
> > Range("BankAccounts").End(xlUp).Offset(1, 0).Select
> >
> > To try to find the first blank cell, but this is returning A1. What have
> > I
> > missed?
>
>
>