I have a sub that populates a worksheet from an access query. How do I those rows into a table using vba?
I found this but it wants a range and the range will change everytime its updated.
When I manually created the table i only needed to click in 1 cell of the data and excel knew the range automatically, so I need to do that action automatically.
Sheets("Pivot SMMT Raw").ListObjects.Add(xlSrcRange, Range("$A$1:$N$16"), , xlYes).Name = _
'No go in 2003
ActiveSheet.ListObjects("Table1").TableStyle = "TableStyleLight2"