Hi all,
i am using a code that loops through a range and finds if any cell is empty.On finding one i use msgbox as-"The cell is empty".
However I want to display the cell which is empty in msgbox.
code used is shown:-
any help will be appreciated.![]()
Rng1.Select For Each Rng1 In Selection If Rng1.Value = "" Then 'Set r = ActiveCell MsgBox "The cell is empty" End If Next Rng1
Bookmarks