Norman,

I am not using any formulas in the ExcelBook, so I tried this code to
retrieve all the cells in the book, but I don't get them in the proper
order: on each row - each cell.

For Each Sheet In ThisWorkbook.Sheets
Set region = Sheet.Cells.SpecialCells(xlCellTypeConstants)
For Each Row In region.Rows
For Each cell In Row.Cells
MsgBox cell.Text 'shouldn't I see all rows, cell by cell ?
Next
Next
Next

Thanks!