-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
headerrowrange
-
A
VBA to delete HeaderRowRange
Hi, I just need to delete the header of a table and copy the body range to another worksheet. But not sure what is not right with the code below, it just not able to delete the header. Following is my code. Dim lo As ListObject Workbooks("WIP_Macro.xlsm").Sheets("WIP").Activate Set lo =...- Ann Ooi
- Thread
- delete headerrowrange listobject vba
- Replies: 3
- Forum: Excel Questions
-
adding comments to ListColumn tables in Excel with Access VBA
My first post. I can usually find what I need and don't need to post but I've come up empty on this one. I am exporting several tables from Access to Excel 2013 with VBA and then formatting the sheets as tables, adding NumberFormats and so on. My titles are abbreviated so I want to add verbose...- TysonC
- Thread
- comments headerrowrange listobjects tables vba
- Replies: 8
- Forum: Excel Questions
-
Removing certain columns based on a list of column headers
Hi, I have a table with several un-needed columns that I'd like to remove. In the VBA code I defined a list (an array) that contains the column headers that will be removed. I devised a solution using ListColumn object (SOLUTION #2), and while this solution works fine, I tried a different way...- boim
- Thread
- header headerrowrange listcolumns
- Replies: 2
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
