Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to limit the Number of rows in Excel sheet

Hi,
I have the requirement to limit the number of rows in
Excel.My backend is MSAccess.Which Excel property does
support the above requirement

subbu
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 634
Default How to limit the Number of rows in Excel sheet

None. You have 65,536 of them and that's that. Now you can hide them of course, but that doesn't
actually get rid of them. If I'm misunderstanding your question, then please post a bit more
detail.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"subbu" wrote in message
...
Hi,
I have the requirement to limit the number of rows in
Excel.My backend is MSAccess.Which Excel property does
support the above requirement

subbu



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I limit the Number of rows in an excel 2007 workbook Mike Setting up and Configuration of Excel 3 June 18th 08 05:49 PM
how do I limit the number of rows when exporting data into excel? Donna Excel Discussion (Misc queries) 3 May 29th 08 02:19 PM
Is there a limit to the number of rows in a excel spread sheet ? Bob's row limit question Excel Discussion (Misc queries) 3 June 30th 06 06:53 PM
How to limit number of rows Excel? Surreal Excel Discussion (Misc queries) 4 March 15th 05 04:03 PM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM


All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"