How to set a column width or row height using an excel function

[ShogunM]

I can retrieve a cell width or height using the CELL function. I would like to use this function to keep multiple sheet in sync with any reformatting done on the first sheet.

Is there any Excel Function that does something like SetColumnWidth(Column,Width) or SetRowHeight(Row,Height) ?

Thanks in Advance

 

[Fishboy]

I can retrieve a cell width or height using the CELL function. I would like to use this function to keep multiple sheet in sync with any reformatting done on the first sheet.

Is there any Excel Function that does something like SetColumnWidth(Column,Width) or SetRowHeight(Row,Height) ?

Thanks in Advance

Hi ShogunM, welcome to the boards.

You can tailor the following macro to suit your needs or at least to get you moving in the right direction:

Sub WidthHeight()
Columns("A:Z").ColumnWidth = 25
Rows("1:100").RowHeight = 25
End Sub

You can change the bold red row / column references to suit your needs, and change the bold green 25's to suit your desired heights / widths.