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 =...
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.