ThePris6ner
New Member
- Joined
- Oct 10, 2018
- Messages
- 1
I'm using Excel 2007
Hi All,
I want to use VBA to check if a Pivot Table Field is bold. This is the code I am using:
This code works if the Bold format is set with the Font Options, but doesn't work if the Bold is set with a PivotStyle.
Is there anyway to use VBA to look at a field in a Pivot Table and tell if it is bold?
This is my first question, apologies if it is not formatted properly.
Thanks for your help.
Hi All,
I want to use VBA to check if a Pivot Table Field is bold. This is the code I am using:
Code:
For iLoop = BottomOfPage To TopOfPage Step -1
For Delay = 0 To 20000000
Next Delay
CellSelect = "A" & iLoop
MsgBox CellSelect
Range(CellSelect).Select
If ActiveSheet.Range(CellSelect).Font.Bold Then
GoTo BreakLoop
End If
This code works if the Bold format is set with the Font Options, but doesn't work if the Bold is set with a PivotStyle.
Is there anyway to use VBA to look at a field in a Pivot Table and tell if it is bold?
This is my first question, apologies if it is not formatted properly.
Thanks for your help.