Thread: [Solved] vba control of shading
View Single Post
 
Old 04-07-2021, 11:28 PM
Tony Tony is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2021
Posts: 12
Tony is on a distinguished road
Default aim

Thank you for your reply.

Removing colored shaded regions is of no interest to me.

My aim is to associate comments/notes which are unique to each shaded region. That is why I want to, as I wrote, "determine the range" for each shaded region. Having that range will allow me to associate the text with the notes/comments. For each document, I have the comments separately in sequential list.

Is there a way in vba to find the range start and end points for each shaded text?
Reply With Quote