Technical forums » Office applications »
Word macro: how to apply highlight to *all* selected text
Thread poster: Samuel Murray
Samuel Murray
Samuel Murray  Identity Verified
Netherlands
Local time: 00:28
Member (2006)
English to Afrikaans
+ ...
Dec 24, 2019

Hello everyone

I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:

Sub highlight_with_shortcut()
Selection.Range.HighlightColorIndex = wdPink
End Sub

Just to be clear, ... See more
Hello everyone

I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:

Sub highlight_with_shortcut()
Selection.Range.HighlightColorIndex = wdPink
End Sub

Just to be clear, the cells that I want to highlight are not next to each other, so I'm holding in Ctrl while selecting additional cells. The macro above then applies to only the cell(s) that I selected last, but I want the macro to apply to all selected cells.

How do I do that?
Thanks
Samuel ▲ Collapse
 
Hans Lenting
Hans Lenting
Netherlands
Member (2006)
German to Dutch
Neem er een loopje mee? Dec 24, 2019

Perhaps you have to insert a loop: for each cell in the range?
 
Rolf Keller
Rolf Keller
Germany
Local time: 00:28
English to German
Just a simple Loop Dec 24, 2019

Option Explicit

Sub highlight_with_shortcut()

Dim singleCell As Cell
Dim allSelectedCells As Cells

Set allSelectedCells = Selection.Cells

For Each singleCell In allSelectedCells
singleCell.Range.HighlightColorIndex = wdPink
Next singleCell

End Sub
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Word macro: how to apply highlight to *all* selected text






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »