Hi
I have an autoexpanding Excel 2016 table that sometimes needs to be reset back to zero (i.e. header + 1 empty row). This works fine, but it will leave some parts of the automatic expansion on the worksheet.
The table has 3 columns with the 2nd column has a colored format + 3rd column has a formula. They both also autoexpand nicely, however when resizing back to start replicated formulas and color formatting will not be cleared. Is there some neat way to clear this as well?
Thanks!
Screenshot (not able to post a pic for some reason):
https://i.imgur.com/X8xxA40.jpg
I have an autoexpanding Excel 2016 table that sometimes needs to be reset back to zero (i.e. header + 1 empty row). This works fine, but it will leave some parts of the automatic expansion on the worksheet.
The table has 3 columns with the 2nd column has a colored format + 3rd column has a formula. They both also autoexpand nicely, however when resizing back to start replicated formulas and color formatting will not be cleared. Is there some neat way to clear this as well?
Thanks!
Code:
ActiveSheet.ListObjects("Table10").Resize Range("$B$15:$F$16")
Screenshot (not able to post a pic for some reason):
https://i.imgur.com/X8xxA40.jpg