View Single Post
 
Old 03-18-2024, 02:17 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

A whole cell:
Code:
Range("A1").Font.Strikethrough = True
Part of the text of a cell:
Code:
Range("A1").Characters(Start:=3, Length:=4).Font.Strikethrough = True
In both cases, if the range is multicelled, contiguous or not, all the cells will be affected.

To toggle:
Code:
Range("A1").Font.Strikethrough = Not Range("A1").Font.Strikethrough
Reply With Quote