Jump to content

MWIProd

Active Members
  • Posts

    33
  • Joined

  • Last visited

Community Answers

  1. 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  
×
×
  • Create New...