I'm having trouble with a section of code because I'm a novice at coding in Excel.
I know how to establish a fixed size for a single cell, but I'm not sure how to do it for the entire sheet. I want to be able to set a fixed size for the comment boxes.
Here is what I tried to accomplish, but it wasn't successful. Any assistance would be greatly valued.
Dim lArea As Long, h As Long, n As Long
n = WorksheetFunction.RoundUp(Len(.Text) / 100, 0)
.Shape.TextFrame.AutoSize = True
h = .Shape.Height
If .Shape.Width > 250 Then
.Shape.Width = 250
.Shape.Height = 250