Forum Discussion
Guus_1905
Mar 14, 2025Copper Contributor
Select cells
How can i select cells with a specific cell style in Excel
JKPieterse
Mar 17, 2025Silver Contributor
You could use a small VBA routine:
Sub FindaStyle()
Dim oSh As Worksheet
Dim oCell As Range
For Each oSh In ThisWorkbook.Worksheets
For Each oCell In oSh.UsedRange.Cells
If oCell.Style Like "*demo*" Then
Application.GoTo oCell
Stop
End If
Next
Next
End SubTaken from my website article on styles: https://jkp-ads.com/articles/styles.aspx