Can't see cells in Excel 2003 1

[newyorkny]

Mornin' Tippers,

I know this is probably a FAQ, but I can't seem to express my question in a way that returns what I'm looking for.

I have a sheet whose VISIBLE cells start at row 1, then leap to row 88. So there are 87 cells in there that contain data (I can query them with INDEX etc.) but cannot be seen.

I looked in the VBA properties for the sheet (F11) and there is nothing there that would suggest the range is hidden.

Cell properties are "locked" (but "hidden" is unchecked if that is relevant).

Freeze panes does not appear to be in play.

Any additional thoughts are most welcomed.

Many thanks,

NY

 

[GlennUK]

Select row 1 and 88 together ( one contiguous lump ), and do Format/Row/Unhide and see what happens.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[newyorkny]

Glenn,

Made out like a squirrel I am afraid.

Nuttin'.

Still jumps from 1 to 88. Row 1 is in regular black type whilst Row 88 is in blue.

Excel is up to something here. *strokes chin*

Thanks for sgnstn!

NY

 

[GlennUK]

Is Autofiltering on? Data/Filter/Autofilter?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[newyorkny]

Glenn,

When I saw you, I said, "now there's a smart guy!"

BINGO!

Perhaps not moviestar looks, but smart (haha).

That's exactly what it was! Should have thought of that meself, but didn't.

Thanks a mill.

NY

 

[GlennUK]

Ha ha, no, not moviestar looks, but my charm wows the ladies anyway ... as well as being smart of course.

Glad that's all sorted. :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.