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