Microsoft Excel Question: Download MS Excel 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
| 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? |