jamienwood
Board Regular
- Joined
- Apr 14, 2002
- Messages
- 133
I know it can be done and its probably really easy but does anyone know how to get to the next clear cell in a column, and select it. For example
Sub NextClearCell()
Range("A1").Select
Selection.End(xlDown).Select
End
This will take me to the last cell with something in but how do i get to the next empty cell???
Sub NextClearCell()
Range("A1").Select
Selection.End(xlDown).Select
End
This will take me to the last cell with something in but how do i get to the next empty cell???