79492979

Date: 2025-03-07 17:03:11
Score: 2.5
Natty:
Report link

Something like this maybe?

Sub DoubleDimensions()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    
    ' Double column width for columns BU:HG
    Dim col As Range
    For Each col In ws.Range("BU:HG").Columns
        col.ColumnWidth = col.ColumnWidth * 2
    Next col
    
    ' Double row height for rows 95:186
    Dim row As Range
    For Each row In ws.Range("95:186").Rows
        row.RowHeight = row.RowHeight * 2
    Next row
    
    ' Double font size for cells in the range BU95:HG186
    Dim cell As Range
    For Each cell In ws.Range("BU95:HG186").Cells
        cell.Font.Size = cell.Font.Size * 2
    Next cell
End Sub

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Low reputation (0.5):
Posted by: Pietro D'Antuono