Msgbox all empty rows in a range

Olly
Fantastic that solves that problem, but now the macro identifies the empty cells between the last used row of the specified range to 191 as well which we dont want.