Hyperlink > Target.Range.Address

[matthewjapp]

Hi there..

I use the code below to jump to a report based on clicking a hyperlink in a master page

If Target.Range.Address = "$A$10" Then
Application.ScreenUpdating = False
Sheets("Scotland").Visible = True
Sheets("Scotland").Select
Sheets("Dump 1").Visible = False
Sheets("Dump 2").Visible = False
Sheets("Pivots").Visible = False
Application.ScreenUpdating = True
Exit Sub
End If


The problem I have is that not every target sheet is the same as the value in (in this example) $A$10.

Some of the sheets are named differently, but there's too much code built around other processes which makes it a whole load of work to rename the sheet to the name in the range A1 (if that makes sense)

For the cells in A1 in the master I click where the value isn't the same as the sheet, I get error message 'reference is not valid'

Can any gurus out there help me with this little problem?

Many Thanks,

Matthew