<div>
I guess what I'm asking is more of a version related question. &nbsp;When the new version comes out or if you're working with an older version, how can you tell what the max number of cells will be?
</div>


I guess what I'm asking is more of a version related question.  When the new version comes out or if you're working with an older version, how can you tell what the max number of cells will be?

<div>
...other than visibly scrolling or jumping to the bottom-right.
</div>


...other than visibly scrolling or jumping to the bottom-right.

<div>
One way I can think of would be a routine that trys the powers of 2 as row and column numbers. The limits are almost always a power &nbsp;of two. Just keep increasing the row until you get an error (which you trap) then try rows in the same way.<br />
<br />
Hope this helps.<br />

</div>


One way I can think of would be a routine that trys the powers of 2 as row and column numbers. The limits are almost always a power  of two. Just keep increasing the row until you get an error (which you trap) then try rows in the same way.

Hope this helps.


<div>
Isn't there a hardcoded value that has this reference in it?
</div>


Isn't there a hardcoded value that has this reference in it?

<div>
I gave you an answer other than NO though!
</div>


I gave you an answer other than NO though!

<div>
<div class="content wysiwyg-content">
Is there an object or DEFINE or variable that represents the last possible cell in a spreadsheet?<br />
<br />
We all know that in Excel 2000, the last cell is IV65536, however, that value (IMHO) should be registered as a constant with the Excel Framework.<br />
<br />
I'm looking for something like <br />
&nbsp; &nbsp;xlLastRangeAddress or<br />
&nbsp; &nbsp;xlLastCellCoordinate or<br />
&nbsp; &nbsp;xlLastRow<br />
&nbsp; &nbsp;xlLastColumn<br />
<br />
or even a value that would go in the SpecialCells function<br />
<br />
ActiveSheet.Cells.SpecialC<wbr />ells( ... &nbsp;).Activate<br />

</div>
</div>


Is there an object or DEFINE or variable that represents the last possible cell in a spreadsheet?

We all know that in Excel 2000, the last cell is IV65536, however, that value (IMHO) should be registered as a constant with the Excel Framework.

I'm looking for something like 
   xlLastRangeAddress or
   xlLastCellCoordinate or
   xlLastRow
   xlLastColumn

or even a value that would go in the SpecialCells function

ActiveSheet.Cells.SpecialCells( ...  ).Activate


Last Possible Cell in Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.