Do you mean the first blank cell in column "A"? Or does the entire row need
to be validated as being blank?
If it's just the first blank cell, you could use this:
Range("A1").Select
Do Until ActiveCell.Value = ""
ActiveCell.Offset(1,0).Select
Loop
When that code finishes, your cursor will be in the first blank cell.
Hope this helps.
Keith
Keith
"Anthony B." wrote:
I need help to find the first blank row in column A and need to select
that cell. Any help would be highly appreciated.
AB
*** Sent via Developersdex http://www.developersdex.com ***