listcolumns

3 years ago as beginner VBA programmer I developed an application for the Food Bank: a "hand-out-list" for food-packages based on client-data in our "dossier"-system. Data extracted with Power Query and "enriched" with a VBA-script to the resulting "hand-out-list". List size about 730 rows...

Hi, I have some code that will go through a table and delete the fields that I have deselected on a different tab. The part where I am having difficulty is the ListObject.ListColumns(#).Delete part. The problem is that the # changes, but I haven't put it in my code correctly to dynamically...

I have an excel table whose column headers are dates, going back to September 2011. There is one date for each day (I'm up to column MY!). In mid-August I added a Macro that would generate new columns automatically and add data from another sheet. It worked fine until the start of this month...

I want the value of the first column in the active row in a ListObject. I've tried MsgBox ActiveCell.ListObject.ListRows(ActiveCell.Row).Range.Address, but don't know how to refer to the first column in this row. I've also tried MsgBox...

How can I create a SQL query based on the column names and values in each row? I've tried to search for a simple and free Excel based database management system, but couldn't find anything. I want to perform the action which i've tried to describe in codes below. For each row in a ListObject I...

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...