Display text when cell is empty

All I want is for the J2:J9 range to display "Paste special" if there is no data in the cells.

Can someone insert the appropriate code in the sheet module?

hopefully im right here. this would be my first successful answer post.

Please Login or Register  to view this content.

Thank you.