System configuration-
MacBook Pro 2020
Catalina v10.15.4
Excel v16.39
VBA v7.1
I'm trying to set the font and font size for my comment. I've gone thru all the posts relative to "Comments" (10 pages) but none of the solutions offered work.
Here's my test code
Sub Test()
With Range("O2").Comment.Shape.TextFrame.Characters.Font
.Size = 16
.Name = "Arial Black"
End With
End Sub
I get this on the "With" line
Runtime error '91':
Object variable or With block variable not set
Other times it complained about the ".shape" or ".textframe".
This seems to work find on a Windows machine, I'm looking for someone to try it on a Mac/ Catalina machine
Thanks
MacBook Pro 2020
Catalina v10.15.4
Excel v16.39
VBA v7.1
I'm trying to set the font and font size for my comment. I've gone thru all the posts relative to "Comments" (10 pages) but none of the solutions offered work.
Here's my test code
Sub Test()
With Range("O2").Comment.Shape.TextFrame.Characters.Font
.Size = 16
.Name = "Arial Black"
End With
End Sub
I get this on the "With" line
Runtime error '91':
Object variable or With block variable not set
Other times it complained about the ".shape" or ".textframe".
This seems to work find on a Windows machine, I'm looking for someone to try it on a Mac/ Catalina machine
Thanks