Don Guillett
12/13/2006 11:54:00 PM
If one column, try ?
Sub firstblankinnamedrng()
Range("BankAccounts").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?