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:

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Sub Macro1()

Dim x As Variant
x = Range("this").Value
Sheets("Calculation").Select
Application.Goto Reference:=x

End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Any help will be appreciated.