Block If without End If

[Oilfield]

Why am I getting a Compile Error: "Block If without End If" with this code?

Please Login or Register  to view this content.

[rcm]

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Oilfield]

That sort of worked... Except that my entire sheet throws £ everywhere now.

[Norie]

This part of the code will be executed whenever any cell on the sheet is double clicked.

Please Login or Register  to view this content.

If you want to restrict the range it's executed on then use If statements similar to those in the preceding code.

[Oilfield]

Thank you Norie