
MWIProd
-
Posts
33 -
Joined
-
Last visited
Community Answers
-
MWIProd's post in _Excel_RangeFind() and empty search was marked as the answer
It works !
Many thanks to all of you. 🙂
Local $oRange = $oWorkbook.Sheets(1).Range("E:F") $oRange.UnMerge() $oRange = $oWorkbook.Sheets(1).Range("E:E") Local $oList = $oRange.SpecialCells($xlCellTypeBlanks) ConsoleWrite($oList.count & " empty cells found" & @CRLF) For $oCell In $oList ConsoleWrite($oCell.Address & @CRLF) Next