lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
hi i am reading a code and part of it is to determine an empty row, please see below.
I could not understand it!! I tried to enter A1=10, A2=20, A3=30
I got 4. So row 4 is empty. So far so good. But when I did A1=10, A2=(empty), A3=30
I got 3 but row 3 is not empty. Is the code below makes any sense to you? Thank you
'Determine emptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
https://www.excel-easy.com/vba/userform.html
I could not understand it!! I tried to enter A1=10, A2=20, A3=30
I got 4. So row 4 is empty. So far so good. But when I did A1=10, A2=(empty), A3=30
I got 3 but row 3 is not empty. Is the code below makes any sense to you? Thank you
'Determine emptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
https://www.excel-easy.com/vba/userform.html