Hi
I see you remove the on error code.
That's why you get the excel error and not the msgbox because there is no empty cell (only formulas)
You must loop through the range to find the first formula that return ""
Dim rng As Range
Dim cell As Range
Set rng = Range("AACash")
For Each cell In rng
If cell.Value = "" Then
cell.Select
Exit Sub
End If
Next cell
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Ron de Bruin" wrote in message ...
Hi tig
Send me your test workbook private then i take a look at it
--
Regards Ron de Bruin
http://www.rondebruin.nl
"tig" wrote in message ups.com...
Ron,
Still got the same 1004 error. Let me know if you have any other
ideas. Thanks for your help thus far.