Home Including a notes column in an excel query
Reply: 0

Including a notes column in an excel query

user849
1#
user849 Published in May 22, 2018, 11:23 pm

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!

Sub IncludeNotes()
'
' IncludeNotes Macro
'

'
    Application.CutCopyMode = False
    ActiveSheet.ListObjects("Table_query").Resize Range("$A$1:$X$506")
    Range("Table_query[[#Headers],[ID]]").Select
    ActiveWindow.ScrollColumn = 1
    Rows("1:1").Select
    Selection.RowHeight = 65

End Sub
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.315531 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO