If the rows beyond 36 are visible (as opposed to hidden), then the file
probably has a small macro in the Workbook module that sets the scrollable
range. Right-click on the Excel icon that is immediately to the left of the
word "File" in the menu that runs across the top of the screen, and select
View Code. That displays the Workbook module. Remove that macro or remark
it out (put an apostrophe at the beginning of every line in the macro).
Save the file, close the file, and open the file and see what you get.
If the rows beyond 36 are hidden (grayed out), click in the small square
immediately above the "1" in the row numbers. This selects the entire
sheet. then do Format - Row - Unhide - OK. This unhides all the rows.
HTH Otto
"shlomop" wrote in
message ...
Somebody sent me an excel sheet, and somehow he blocked that I can't go
after line 36, I tried all ways that I know, and I can't figure it
out.
Can anybody help me figure this out?
Thank you
--
shlomop
------------------------------------------------------------------------
shlomop's Profile:
http://www.excelforum.com/member.php...fo&userid=9734
View this thread: http://www.excelforum.com/showthread...hreadid=562535