Excel - Row Height +1 VBA

Hi Experts,
I need VBA to increase all rows in my table by  +3

>>>>> This is my table
   >>>>>>>>>>>      Range("Table1").Select

All the rows are not the same height, but I want them all to increase by a set value.
And after I print the sheet, I will select all the same rows again and decrease them all by the same amount.

Thanks so much
Chris
chris pikeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MacroShadowConnect With a Mentor Commented:
Try this
Sub Demo()
    Dim row As Range
    For Each row In Range("Table1").Rows
        row.RowHeight = row.RowHeight + 3
    Next row
End Sub

Open in new window

0
 
chris pikeAuthor Commented:
Awesome thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.