I have what I am sure is a very simple problem that is likely to have an equally simple solution.

I have a workbook ("Triage.xlsm") that has four worksheets named “Data1”, “Data2”, “Data3” and “Data4”. At the moment I have a declared variable which gets utilised in various submacros which I am sure will also be required to answer my query.

Dim ws As Worksheet
There is a submacro called “Markers” that will need to be run on “Data1” or “Data3” if either of them contains data. There are occasions when only “Data1” will contain data, so obviously the submacro needs to only be run on “Data1”. I'd also need it to tell the user if both "Data1" and "Data3" contains no data.

I’m certain that some sort of error checking needs to take place but cannot fathom out how to do the above.

Help will be very much appreciated.

Many thanks!