View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default steping through all cells

Hi Lars,

Try changing:

For Each cell In Row



to

For Each cell In Row,Cells


---
Regards,
Norman


"Lars" wrote in message
...
I am trying to analize all cells, one by one. I have tried this code:

For Each Sheet In ThisWorkbook.Sheets
For Each Row In Sheet.Rows
For Each cell In Row
MsgBox cell.Text
Next
Next
Next

But I get a "non valid use of Null" error. Any hints ? Thanks,