Hi, I have a small section of code in a workbook originally designed for use in Excel 2003
The purpose is to hide all rows, from one containing a defined cell named "EndRowMarker", down to the last row in the worksheet.
I have adapted the code so that it works in Excel 2013:
What I would rather do is have some non-version-specific code so that the same workbook would work in either environment.
I suppose that I could achieve this by first trying row 1048576 but with an error trapping line so that if this returns an error state to ignore and reset the error state and then re-do the exercise restricting it to row 65536.
That seems a little inelegant, and I have a vague recollection that Excel recognises some "special cells", which might include the last row of the worksheet. Would this be available and, crucially, identically defined between versions 2003 and 2013?
Any suggestions gratefully received.
Bookmarks