Can someone explain how to use a Search Descriptor and FindAll() in order to determine if all cells in the same column contain the same exact value?
oSelection = oConstantSheet.getCellRangeByPosition(iColumn, iStartRow, iColumn, iRowCount) 'nLeft, nTop, nRight, nBottom
'nLeft is the column index of the first cell inside the range.
'nTop is the row index of the first cell inside the range.
'nRight is the column index of the last cell inside the range.
'nBottom is the row index of the last cell inside the range.
oDescriptor = oSelection.createSearchDescriptor()
oDescriptor.SearchString = sConstantValue
oDescriptor.SearchWords = True
oFoundAll = oSelection.FindAll(oDescriptor)
I don’t know how to access oFoundAll
in order to find out how many sConstantValue
were found