Microsoft Excel Interview Question:

How do I find the first empty cell in column A?

Submitted by: Administrator

If ActiveSheet.UsedRange.Count < 2 Then
MsgBox 1
Else
MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row
End If
Submitted by: Administrator