2007 Rows??

J

John McCabe

Was trying to show how 2007 will go to 1 mill rows. Can do it open > new
BLANK worksheet.
Click to expand...
How can I do it if the worksheet is already existing and just want to show
HOW it can go to more rows than will ever need.
 
J

Jarek Kujawa

if you want to go to 1,000,000th row press CTRL+G and in "reference"
window insert A1000000, then press OK
 
R

royUK

Not really sure what you mean, maybe

Code:
--------------------

Option Explicit

Private Sub Workbook_Open()
MsgBox ActiveSheet.Rows.Count
End Sub
 
H

Harald Staff

If it is an existing xls file, save as xlsx or xlsm in Excel 2007. Close and
reopen, and it should have lots of fresh new rows and columns.

HTH. Best wishes Harald
 
R

royUK

Harald said:
If it is an existing xls file, save as xlsx or xlsm in Excel 2007. Close
and
reopen, and it should have lots of fresh new rows and columns.

HTH. Best wishes Harald
Click to expand...

The number of rows and coluimns remains constant, what do you mean by
new?
 
D

Dave Peterson

I'm sure Harald meant that you'll see lots more than the 64k rows and 255
columns. Those additional rows/columns are "new".

Try Harald's suggestion once more. Make sure you save it in that nice new
format.

If that doesn't work, then include the choice of fileformat you made on that
saveas dialog.
 
J

John McCabe

Sorry to report I did forget about the extra X on the end to make it
version 7. Thank you one and all.
if you want to go to 1,000,000th row press CTRL+G and in "reference"
window insert A1000000, then press OK
 
Top