Hyperlink little problem....

[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

 

[GlennUK]

According to that code there is no test of the value in $A$10 anyway. I think you need to explain more about what's going on, and what you require, and maybe show more relevant code.

 

[matthewjapp]

Thanks Glenn, I had a look at the code and realised that some of my cell references for the actual hyperlink was out of sync...schoolboy error on my part )