I'm looking to include a notes column next to a query from an incident management site and to also make sure that the header row stays the same size.
Here's what I have so far. When I run it, it includes the notes in the table so they will refresh and follow the different incident statuses without losing the notes, but the way I wrote it doesn't allow for new rows.
The header row sizing isn't super essential, but that isn't working at all.
Any help would be greatly appreciated!
' IncludeNotes Macro
Application.CutCopyMode = False
ActiveWindow.ScrollColumn = 1
Selection.RowHeight = 65