Find last cell in a spreadshhet using VBA

How about you post a dummy workbook with sensitive info taken out, so we can actually see what you want.

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