Microsoft%20Excel%20Interview%20Questions%20and%20Answers
Question: How do I find the first empty cell in column A?Answer: If ActiveSheet.UsedRange.Count < 2 ThenMsgBox 1 Else MsgBox Columns("A:A").Find(What:="", LookAt:=xlWhole).Row End If |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?