View Full Version : [SOLVED:] What happened to this sheet
anandbohra
09-03-2007, 06:12 AM
hi all
i had downloaded certain files from smf addin yahoo group
the strange thing i noticed is there is no VBA but there is only limited scope to browse the worksheet (say only range A1:J150)
pl look this & detailed me if any body have any idea
You can run code once to set the ScrollArea property of a worksheet to a particular range. You don't need to store the code in the workbook.
You can also set the Scroll Area directly in the properties window in the VBEditor.
anandbohra
09-03-2007, 09:49 PM
Thanks rory but in VBEditor when i set the Scroll area to $A$1:$J$10
this shows whole sheet but scrolling is limited in this area only.
but in the attached file as u can see after column M there is grey shaded area which let us feel that sheet has only column m instead of column IV
same way after row 152 u can not see below is which again looks like this is small sheet of column M by row 152 instead of standard Column IV by Row 65536.
hope u got it.
Pl tell me how to do that as u can see in the attached file (already attached in 1 post named limited data.xls)
mdmackillop
09-03-2007, 11:59 PM
The rows and columns are hidden. Select the whole area and unhide rows and columns or
Sub unhide()
With Cells
.Rows.Hidden = False
.Columns.Hidden = False
End With
End Sub
anandbohra
09-04-2007, 12:14 AM
Thanks mdmackillop
I wonder how come this small thing missed in my mind :eek:just unhide cells.:dunno
thanks to all
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.