AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
I have this but it isn't working
It returns a 3 when the first blank row is 2. It need not look past Column "A" either, so first blank "A" would do.
VBA Code:
Function FirstBlankRow(Sheet)
With Worksheets(Sheet)
FirstBlankRow = .Cells.SpecialCells(xlCellTypeLastCell).offset(1, 0).Row
End With
End Function
It returns a 3 when the first blank row is 2. It need not look past Column "A" either, so first blank "A" would do.