View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lars[_3_] Lars[_3_] is offline
external usenet poster
 
Posts: 4
Default steping through all cells

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,