Cell width and height

I would like to set all the cells in my worksheet to:
cell height 17
And for A to R width 39.

Also I would like to do this for multiple worksheets. For example tabs across the bottom from 2 to 6.
WTC_ServicesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NorieConnect With a Mentor VBA ExpertCommented:
If you mean will the cells that are merged have their row and height changed then yes, but the cells will still stay merged.
0
 
NorieVBA ExpertCommented:
Try this.
Dim ws As Worksheet
Dim I As Long

    For I = 2 To 6

        Set ws = Worksheets(I)

        ws.Range("A:R").ColumnWidth = 39

        ws.Rows.RowHeight = 17

    Next I

Open in new window

0
 
WTC_ServicesAuthor Commented:
Perfect thanks.

Will this effect merged cells?
0
All Courses

From novice to tech pro — start learning today.