below code detects empty rows on the Active Sheet's used range. The blank rows are displayed one at a time in a msgbox.
Could somebody help me re-write this code with the following requirements:
The blank rows are to be displayed in just one message box, such as: Rows 5, 7, 9 are empty
blank rows are detected the macro has to call up another macro called 'Lookup_My_Range'
Help is much appreciated. Thank you very much in advance.
Dim row As Range
Dim sheet As Worksheet
Set sheet = ActiveSheet
For i = 1 To sheet.UsedRange.Rows.Count
Set row = sheet.Rows(i)
If WorksheetFunction.CountA(row) = 0 Then
MsgBox "row " & i & " is empty"