Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
With ActiveWorkbook.ActiveSheet.
    .Formula = "=" & Split & "/C1*100"
    .NumberFormat = "0"
    .Borders.LineStyle = xlContinuous
    .BorderAround Weight:=xlMedium
    .RowHeight = 17.5
    .Font.Bold = True
    .Font.Size = 12
    .EntireColumn.AutoFit
    .EntireRow.AutoFit
End With

...