Попробуйте так
Sub ChangeRowColHeight()
Dim rc As Range,ws as Worksheet
Dim bRow As Boolean
bRow = (MsgBox("Изменять высоту строк?", vbQuestion + vbYesNo, "www.excel-vba.ru") = vbYes)
'bRow = True: для изменения высоты строк
'bRow = False: для изменения ширины столбцов
Application.ScreenUpdating = False
for each ws in activeworkbook.worksheets
For Each rc In Intersect(ws.Range("E:G"), ws.Usedrange).cells
RowColHeightForContent rc, bRow
Next
Next
Application.ScreenUpdating = True
End Sub