ol_Template").Cells(1, C).ColumnWidth
End If
Next C
End If
Next I
Sheets(CurSheet).Select
Sheets("Col_Template").Visible = False
End Sub
Either way, these routines updated 100+ column widths in 50 sheets in 2-3
seconds.
let me know if
First attempt at this, so hopefully this is how it works
I have a spreadsheet with about 25 tabs and about 200 columns with
lots of different widths. As its updated by many the widths get moved
about. Before it is released, I run a macro to go through each column
in each tab and restore it to it
