Integrating an IF into a Case select

[jshaw82]

Can anyone help me with something:

I am running a Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) and I am using the Select Case option.

Please Login or Register  to view this content.

Whilst I still want the code to run on Sheet2 but on a different range of cells. I was trying to use some sort of
IF Case = sh.Sheet2

**range code**

Else

**range code**

But it doesn't like it - I might be doing it completely wrong.
I'd appreciate any help.

Thanks

John

[Norie]

John

Perhaps structure things like this.

Please Login or Register  to view this content.