A lot safer than changing a cell's content would be to show the status
bar if appropriate.
Changing a cell requires (at a minimum) the following assumptions:
The cell is in the visible portion of a window.
That portion of the window is not obscured by another window
The cell is empty
Changing that cell will not trigger any other cascading changes
Changing the workbook's status to 'dirty' is acceptable
Neither the cell's row and column is hidden.
The cell's height and width are sufficiently large to show the progress
status
The cell's format (font size, color, pattern color, etc.) allow for a
visible progress status.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions