Run-time error '91': Object variable or With block variable not set

Hello. I have the below code in my worksheet. There is no other code but that listed below in the worksheet.

Please Login or Register  to view this content.

If I click in any cell in rows 1 through 12, I receive a "Run-time error '91'" message. I need to be able to click and type in a few cells in rows 1 through 12. How do I avoid this error?

Thanks!

When do you want that code to run?

Is there a particular range?

So if I select a cell in row 456 column Z the code should run?

Try this.

Please Login or Register  to view this content.