Excel 2007 Row and Column Limits

  VoG II 20:47 11 Jun 2006

These are going to be greatly increased from the current 65,536 * 256 limitation click here

This is great news but it means that if you have used code like

LastRow = Range("A65536").End(xlUp)

to return the last used row, it may no longer function correctly.

The following will work:

Sub test()
Dim LastRow, LastCol
LastRow = Cells(Rows.Count, 1).End(xlUp).Row
LastCol = Cells(1, Columns.Count).End(xlToLeft).Column
MsgBox LastRow
MsgBox LastCol
End Sub

  spikeychris 20:52 11 Jun 2006

Say that again in English.

  VoG II 20:55 11 Jun 2006

If you wrote a macro in Visual Basic for Applications that assumed the last row could not be greater than 65,536 it may fail since the new maximum row is 1,048,576.

  spikeychris 20:59 11 Jun 2006

Do you know...that has bothered me for ages.

  Woolwell 21:26 11 Jun 2006

Thanks VoG.

  spikeychris 21:35 11 Jun 2006

Yeah good call.

  Forum Editor 23:09 11 Jun 2006

Excel hasn't exactly been my strong suit - I am very happy in Word, Powerpoint is second nature, Access isn't exactly a mystery to me, and Publisher is an open book, but Excel........

That might start to change with Office 2007 however. I've been beta testing the software for quite a while now, and I have to say that I find Excel a lot more friendly. Those new toolbars are a joy to use, and the the whole thing suddenly seems a little easier. I'm not saying that I'm any kind of an expert you understand, but there's definitely some light showing at the end of the tunnel.

Well done, Microsoft.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)