Page History

Wiki MarkupIn VBAProject, in \ [Modules\]-->Module2 Code section, I find these macros that were, probably, auto-recorded by Rob when carefully running through the canonical set of keystrokes in Macro recorder.    Evidently the \ [Modules\]-->Module1 section has the code for the results autoformatting, which in the etc-surveys sheet at least was not being used.    But it is concatenated to the list of routines below. \\ \\

Sub ResultsAutoFormatWeek()
'
' Autoformatweek Macro
' Macro recorded 3/2/2004 by smyser -- auto formats this weeks comments table
'
' Keyboard Shortcut: Ctrl+f
'
    Selection.AutoFormat Format:=xlRangeAutoFormatList3, Number:=True, Font:= _
        True, Alignment:=True, Border:=True, Pattern:=True, Width:=True
    Columns("C:C").ColumnWidth = 6.14
'    ActiveWorkbook.Save
End Sub

...