Hidden Rows
 

I am using an EXcel XP workbook which is relatively small in terms of the
amount of data it holds. Several of the rows keep 'disappearing'. If I try
to 'unhide' them nothing happens. If I hover the mouse pointer of the row
markers it will allow me to drag them wider. I then save the workbook.

After making some more changes in other parts of the workbook the rows have
disappeared again.

I can't work out what is happening as it doesn't seem to be any of the
formatting options. And as far as I can tell I am not changing any settings
by accident.

Hopefully one of you clever people out there will know what the heck I'm
doing wrong.

Thanks in advance of help.

Geoff

Hidden Rows
 

Do you have any code that would change the row heights to 0?

Perhaps event code behind a worksheet?

Or in Thisworkbook module?


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 05:58:01 -0800, geoff_francis_cox
wrote:

I am using an EXcel XP workbook which is relatively small in terms of the
amount of data it holds. Several of the rows keep 'disappearing'. If I try
to 'unhide' them nothing happens. If I hover the mouse pointer of the row
markers it will allow me to drag them wider. I then save the workbook.

After making some more changes in other parts of the workbook the rows have
disappeared again.

I can't work out what is happening as it doesn't seem to be any of the
formatting options. And as far as I can tell I am not changing any settings
by accident.

Hopefully one of you clever people out there will know what the heck I'm
doing wrong.

Thanks in advance of help.

Geoff