Shared workbook size.
I have a question that concerns the CurrentRegion of a worksheet.
I execute the following code to find the last row in the workbook: activecell.specialcells(xllastcell).select set ocurrentregion = selection.currentregion iLastRow = ocurrentregion.application.activecell.row this all works fine until the worksheet range extends to row 65,xxx+, my question is what defines the 'currentregion' I originally thought this was the last non-blank cell but I have tried deleting any formating in the cells below the data area and extending to row 65,xxx and the currentregion stays the same. The solution I found is to cut and paste to a new workbook and all is good again. Seasider. |
Shared workbook size.
http://www.contextures.com/xlfaqApp.html#Unused
-- Regards, Tom Ogilvy "Seasider" wrote in message ... I have a question that concerns the CurrentRegion of a worksheet. I execute the following code to find the last row in the workbook: activecell.specialcells(xllastcell).select set ocurrentregion = selection.currentregion iLastRow = ocurrentregion.application.activecell.row this all works fine until the worksheet range extends to row 65,xxx+, my question is what defines the 'currentregion' I originally thought this was the last non-blank cell but I have tried deleting any formating in the cells below the data area and extending to row 65,xxx and the currentregion stays the same. The solution I found is to cut and paste to a new workbook and all is good again. Seasider. |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com