Find empty cell in Column

[thaykhov]

Hi I have a worksheet when I want to loop through column N to find any empty cells.

The number of rows is variable.

I also want it to come up with a message prompt
Can anyone help.

Thanks

T

[lexusap]

Hi,

Hey fellow Australian, please see attached file... or you can copy the code below!

Please Login or Register  to view this content.

Cheers,

Lex!

[Sa DQ]

Option Explicit
Sub GPE()
 Dim Cls As Range
 For Each Cls In Columns("N:N").SpecialCells(xlCellTypeBlanks)
    MsgBox Cls.Address
 Next Cls
End Sub 

[thaykhov]

Great thanks for the prompt response