Hi Paul,

its another 2016 problem -

Had quite a few issues this year.

#2 - gives an error - when I dismiss it and press the END BUTTON - it applies the styles any way.


#4 - Same Thing - applies it only when I dismiss the error.


I don't understand why it's playing up like this - maybe I need to add an on error resume somewhere?

I guess I will have to live with it. I was going to run this macro on a folder full of files - I will see what happens.


Apart from that thank you so much for all the coding help these past few months.

You can understand my frustration with VBA - not the most graceful of programming languages.

I have some absolute fantastic gems from you - that will make such a difference to my stress levels next year.

I cant thank you enough again for helping all the newbies like me who present you with the most miss mashed chunks of code to grace your eyes. Often times out of desperation we are known to try and mix and match code blocks - as if you didn't know already.

You can always spot the amateurs, we do try

Microsoft doesn't make it any easier - some of the help materials online for VBA are hilariously sad - generous individuals such as yourself who have the patience to code VBA are a treasure and asset to the community!


So thank you!

I would be lost without all the help - banging away at the keyboard for days on end - as is my usual, with the will to live slipping away with every new iteration of a vba line that fails to make the grade!

I hope you will have the most awesome Xmas holiday.

Wishing you and everyone on this forum a happy holiday!

And a wonderful 2016.


J


Cheers from across the pond!


****Double Solved Extra Stars

If I can solve the problem of this mysterious error - I will update the thread in future - apart from that Solved


PS - My 2015 has been great thanks to your help!