I have a number of sheets in a workbook.
Each sheet has various rows of data. I have a For..Next loop to open each sheet.
Each sheet must be analyzed for zero balances in COL M.
A nested Loop controls the number of times to go "down" the Col. If the cell >0, then the loop continues "down" CoL M.
The available number of rows may not contain data and at a point the next sheet is opened.
The starting Cell is Selected and it's value returned. If the value = 0, Then, I must Scroll to Left and test the cell for data.
After the first starting cell, when scrolling is done, "down" and or "left", I cannot get the value of those cells.
The Cursor is not there so I cannot Activate and/or Select the cell for testing.
(ClearContents), is performed based on 0 value in Col M
and >0 value in Left cell. Other non-contiguous cells are then also cleared of contents, which means that I must have access to those cells, (Activated and/or Selected).
How can I get values in those?
2007-11-23
06:48:36
·
3 answers
·
asked by
ed
7