PapaDos
12/13/2006 11:53:00 PM
Range("BankAccounts").specialcells(xlCellTypeBlanks).Cells(1).select
NOTE:
This will generate a runtime error if there is no blank cells in the range,
so you need to trap it with an On Error statement...
--
Regards,
Luc.
"Festina Lente"
"BOBODD" wrote:
> 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?