LinkBack URL
About LinkBacks
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
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
Last edited by thaykhov; 06-13-2014 at 01:45 AM.
Hi,
Hey fellow Australian, please see attached file... or you can copy the code below!
Formula:
Please Login or Register to view this content.
Cheers,
Lex!
PHP Code:Option Explicit
Sub GPE()
Dim Cls As Range
For Each Cls In Columns("N:N").SpecialCells(xlCellTypeBlanks)
MsgBox Cls.Address
Next Cls
End Sub
Great thanks for the prompt response
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks