View Single Post
 
Old 10-24-2021, 12:40 PM
effimera effimera is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2021
Posts: 8
effimera is on a distinguished road
Default Vba: Selecting table cells by fill colour

Hi there,

I was wondering if it is possible to create a macro that selects table cells with a specific fill colour.

In MS Word, I've got a table with 4 fill colours. The table extends over 300 pages, and I would need to select only two colours (if one at a time, that's OK, but the quicker the better), then to delete them.

I tried an alternative procedure by using Excel:
copy & paste > apply Filter by Colour > delete
However, this method is unsatisfactory in that Excel automatically sets the List and thus some unique numbers as General, resulting in a recalculation with entirely different numbers/codes (such as 8,15381E+11 instead of 815381020338 or 5.V instead of 5/5).

Therefore, I'd much prefer to use a macro in Word, if that's even possible.

Thanks a lot!
Reply With Quote