Hello JoeSkittles,
Thanks for the workbook. I could not have made this revision with out it. Here is the revised code...
Sub Macro6()
'
' Macro6 Macro
'
' Keyboard Shortcut: Ctrl+Shift+T
'
Dim oTable As ListObject
ActiveSheet.ListObjects.Add(xlSrcRange, Selection, , xlYes).Name = _
InputBox("What is the name of the table?")
Set oTable = ActiveSheet.ListObjects(ActiveSheet.ListObjects.Count)
oTable.TableStyle = "TableStyleMedium16"
With oTable.HeaderRowRange
.Font.Name = "Calibri"
.Font.Size = 9
.Font.Strikethrough = False
.Font.Superscript = False
.Font.Subscript = False
.Font.OutlineFont = False
.Font.Shadow = False
.Font.Underline = xlUnderlineStyleNone
.Font.ThemeColor = xlThemeColorLight1
.Font.TintAndShade = 0
.Font.ThemeFont = xlThemeFontMinor
End With
With oTable.HeaderRowRange
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
With oTable.DataBodyRange
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Range("L2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
With Selection.Font
.Color = -65536
.TintAndShade = 0
End With
With Selection.Font
.Name = "Calibri"
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.Color = -65536
.TintAndShade = 0
.ThemeFont = xlThemeFontMinor
End With
End Sub
Bookmarks