worksheet size limit

[Sachin Narute]

Hi all,
I want to use only 500 cells and A to N cells not ore than 500 cells.
i want to limit this no of cells.

Regards,
Sachin

[dominicb]

Good morning Sachin Narute

You have two options:

(1) Hide columns O to IV and rows 500 to 65,536. This will give the appearance of a spreadsheet set on a 14 x 500 grid.
(2) Use the ScrollArea command thus:

Worksheets(1).ScrollArea = "A1:N500"

Once run this macro will display the whole sheet but restict the users movements to your prescribed range. This would not be saved with the workbook, but you could run this from your Workbook_Open event so that it is run when the file is opened.

HTH

DominicB

[Roger Govier]

Right click on the sheet tab of your workbook and choose View Code.
When the Visual Basic Editor window opens, look for the Sheet Properies
section (press F4 if it is not visible)
In Scroll Area, set the range to be $A$1:$N$500
Press the Xcel icon at top left of window to return to your sheet.

You will now be restricted to only entering data or scrolling within the
range A1 to N500


--
Regards

Roger Govier


"Sachin Narute" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
> I want to use only 500 cells and A to N cells not ore than 500 cells.
> i want to limit this no of cells.
>
> Regards,
> Sachin