Friends,
I want to sort a set of data in a macro. For this I need the address of last cell in a data base to be found out automatically. For example if the whole data is in the range of A1:F45, the address of F45 should come automatically or the address of last cell (F45) has to be found out automatically for carrying out sorting further. Is there any programme to find this automatically?

Regards