Use value in Named cell to search for text

Hi

I'm trying to run a "search type macro" in Excel whereby it looks up a value in a Named cell and then uses this information to search and match to data on a seperate worksheet.

The Named cell is called "this" with the following value "AS41005.2". These are in a worksheet called "Sections".

When I press a button to run a macro, it should look up the value "AS41005.2" in another worksheet called "Calculation" and then land on it - just like the FIND function in excel.

I have no problem with installing and using the button, but can't get the programing to work out.

My code (which isn't working) is:

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Please Login or Register  to view this content.

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Any help will be appreciated.

Thanks very for the code you wrote it seems to work. Much appreciate the quick response. Also thanks for the advice on forum etiquette