Finding the the last cell address for writing macro

Originally Posted by rms10

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

Hi,

perhaps not the best way, but my preference is to Dim iLastRow as long, and then

Please Login or Register  to view this content.

which sets the variable according to column A last entry for use in the command.

hth
---