Microsoft Excel Question:
Download Questions PDF

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

Answer:

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

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Is it possible to change the color and font of the sheet tabs?How can I unprotect a VBA project using code?