Can anyone give me a clue to the following puzzle in Excel 97?
I have a .csv files containing a table which has several columns and rows of data. The number of rows could change and hence this is not fixed. The number of columns are fixed.
How can I find the last “occupied” cell of any one of columns in that table using VBA or any other feature?
The answer can only replate to Excel 97 and NOT above.
