Microsoft Excel Question:
Download Job Interview Questions and Answers 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
MsgBox 1
Else
MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row
End If
Download MS Excel Interview Questions And Answers
PDF
Previous Question | Next Question |
Is it possible to change the color and font of the sheet tabs? | How can I unprotect a VBA project using code? |