To run or not to run - VBA Code

[colin.dickson]

Hi All,

I'm looking to add some code in the front of the below to pull up an error message if theres no data in cell D4 to format/filter and then end... message something like "There's no data to format".

Please Login or Register  to view this content.

Many thanks in advance

Colin

[TMS]

After the With Sheets( ...:

Please Login or Register  to view this content.

Regards, TMS

[colin.dickson]

It still doesn't like that.. I now have the following code;

Please Login or Register  to view this content.

[TMS]

It still doesn't like that..

What does that mean? Do you get an error? If yes, what? What line of code errors? Or does it just not do what you expect?

You realise we have nothing to test any theories on, nor do we know what you expect the code to do.

Regards, TMS

[colin.dickson]

Test.xlsmYes I get the Error 424 and when debug is clicked ' .AutoFilter' is highlighted.

please see the attached example - When i click 'RUN' I would like, if there's no data from row 4 to show and error "No Data to format" and if there is follow the rest of the code.

thanks again for your help.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS