Hi Lars,

For me, your code traverses each sheet, row by row, e.g.:

A1 B1 E1 K1
A2 E2 J2
A4 B4

I do not, therefore understand your comment:

'shouldn't I see all rows, cell by cell ?


---
Regards,
Norman



"Lars" wrote in message
...
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!