SyntaxFix
Write A Post
Hire A Developer
Questions
The overall dimensions of a range are in its Width and Height properties.
Width
Height
Dim r As Range Set r = ActiveSheet.Range("A4:H12") Debug.Print r.Width Debug.Print r.Height