View Single Post
 
Old 03-06-2022, 04:42 AM
Guessed's Avatar
Guessed Guessed is online now Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,177
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote