Columns and Rows
Greetings,
How can I find the number of active columns and rows used in an excel work sheet? What I mean is how can i find the last column and row or cell position, where the data is stored in an excel sheet? A code snippet will be of great help. Thanks for your cooperation and help. Best regards, Anand |
Columns and Rows
Hi Anand,
Ctrl+End will tell you what Excel thinks is your last cell. If that is incorrect, I would suggest fixing all sheets by running a macro see Debra Dalgleish's code Why do my scrollbars go to row 500 -- my data ends in cell E50 http://www.contextures.com/xlfaqApp.html#Unused Since this is not the programming newsgroup, you might need instructions for installing and using a macro see http://www.mvps.org/dmcritchie/excel/getstarted.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Anand" wrote in message ... Greetings, How can I find the number of active columns and rows used in an excel work sheet? What I mean is how can i find the last column and row or cell position, where the data is stored in an excel sheet? A code snippet will be of great help. Thanks for your cooperation and help. Best regards, Anand |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com