steping through all cells

Posted to microsoft.public.excel.programming

Lars[_3_]

external usenet poster

Posts: 4

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value	Spence	Excel Worksheet Functions	3	February 13th 11 05:33 AM
compare 2 column cells and return the adjacent columns cells data of the cell	trebor57	Excel Worksheet Functions	1	February 1st 11 02:54 PM
display a range of cells editible cells based on matching date	Miki	Excel Worksheet Functions	0	October 10th 07 03:27 PM
Setting of input cells as blue font and formula cells as black fon	Sunnyskies	Excel Discussion (Misc queries)	2	May 14th 07 05:27 PM
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells	Wescotte	Excel Programming	1	June 6th 05 07:00 PM

All times are GMT +1. The time now is 01:54 AM.

Menu

About Us