Macro code to check data is entered in cell ‘A2’ before running macro

Hi,

Can anyone please advise me of the macro code I need to add to my existing code to only run the macro if there is data in cell ‘A2’ on my ‘Input Data’ worksheet?

If there is no data entered in ‘A2’ a message should be displayed i.e. “Please check you have entered data in the Input Data’ worksheet”

Many thanks in advance for any assistance received

Regards


Rob

just add the below at the start of your existing code,

Please Login or Register  to view this content.

isskint,

EXCELLENT !! Just what I wanted.


Many thanks


Regards

Rob