Search a sheet for content

[CDandVinyl]

I wonder if someone can advise on a small macro.

I'd like to search my workbook for a 'sheet1'. It doesn't need to be opened necessarily , but the macro should check it for any content.

Where sheet1 has no content and is empty , a popup would state 'No Content in sheet1'.

Where sheet1 has content , end the macro with no further message or action.

Can someone help with some VBA to satisfy this?

Grateful for any help.

[TMS]

Maybe this:

Please Login or Register  to view this content.

[CDandVinyl]

Thanks TMS - this does the job perfectly.

[mjr veverka]

A small modification to TMS code:

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.

[CDandVinyl]

Thanks guys.