Find last cell in a spreadshhet using VBA

Originally Posted by jeffreybrown

Haven't really followed any of the other suggestions, but try this.

In column A the formula goes down to A17, but the last value is in A5.

Thanks for your input this has half worked, it has given me thwe cell to which i need selecting but i have tried to change the code to select the cell instead of given me a msg box.

I have attached a file to which may help you help me

In this sample the formulas on sheet 1 are looking at sheet 2 but the original looks at many different sheets. But on this sheet 1 i am trying to get vba to select the last cell with a value which is A457 (although its not always A457)

Again thanks for all your help