kiggsondrome
asked on
Find the first empty cell in current range (VB)
How do i find the first empty cell in the current range and make
it the active cell?
it the active cell?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Selection.SpecialCells(xlC ellTypeBla nks).Cells (1,1).Sele ct
(°v°)
(°v°)
too late... (^v°)
ASKER
Thanks!
Works for me like this:
For Each oCell In Selection.Cells
If (oCell.Value = "") Then
oCell.Select
Exit For
End If
Next