You need to go back and look at the code from the earlier thread. It is a slippery slope to apply direct formatting to your content when you 'should' be using styles to make things consistent. All you need to do is one line to apply the desired style.
With the above code you have gone back to using Selection but perhaps you aren't sure what you selected. What was it that you wanted the macro to format. Your code is selecting a cell which might contain more than one paragraph. Are you trying to format every paragraph in every cell?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|