listobject

  1. M

    Need to use AutoFilter on multiple tables within a single VBA code

    I have created a very simple VBA code that automatically applies a filter on the single column I have filtered on a table, which I have named “BB.Tbl1”. However, I want the VBA to apply to multiple tables that are all on the same worksheet, so I want it to include my other tables named "BB.Tbl2"...
  2. T

    How to Refer to Contiguous ListColumn Ranges by Index

    Hey all, I'm writing a macro to set the source data of a chart to several contiguous table columns but I'm stumped at the syntax. The table column headers can change so I'm trying to refer to their index numbers instead. 1 Dim Table1 as ListObject: Set Table1 = Sheet1.ListObjects(1) 2 Dim...
  3. wsnyder

    Power Query Background Refresh False Error

    Hi all, Using Excel 365. Is my the background refresh false tripping over another background refresh? I'm getting There are 4 worksheets each with 1 Table created from Power Query Close & Load With wb For Each ws In .Worksheets For Each lo In ws.ListObjects...
  4. E

    Sorting table gives error

    I'm having a bit of trouble with sorting a table using VBA. The macro I'm using is this Private Sub test() Dim lo As ListObject Set lo = HCP_justering.ListObjects(1) lo.AutoFilter.ShowAllData With lo.Sort .SortFields.Clear .SortFields.Add _...
  5. wsnyder

    ListObject AutoFilter FilterMode

    Hi all, Using Excel 365. My snippet is throwing an error here If lo.FilterMode Then Not sure why that is? Thanks -w Full snippet: Sub ShowAll_Lists() Dim wb As Workbook Dim ws As Worksheet Dim lo As ListObject Set wb = ThisWorkbook For Each ws In wb.Worksheets For Each lo In...
  6. 5

    Speed up an Autofilter with 20k+ rows

    Hey everyone. Hope you're all doing well. I have a listObject table with 20k+ rows that I'm filtering with a textbox. This is the code I modified a little from extendoffice: Private Sub TextBox1_Change() 'Update by Extendoffice 2018/08/22 Dim xStr, xName As String Dim xWS As Worksheet Dim xRg...
  7. Rita F

    Find , mark and filter duplicates at ListObject (column of Dynamic Table) VBA

    Hi I am trying to find, mark and filter duplicates at ListObject (column of Dynamic Table) VBA without success. The Following script works great for the regular range, I made some changes and need it for the list object. I will very much appreciate your assistance Sub Duplicates()...
  8. A

    Table object declaration causing cells outside of table to change

    I wrote a code to convert text input files to a structured excel sheet as defined cells and tables I had created several cells and assigned values through the text input, using csng to convert text to values. Then I formatted a set of values into a listobject table within the VBA. However...
  9. 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 =...
  10. I

    ListObjects and Table's cell column - Insert records by column name [VBA]

    Good evening everyone. I need your help building an "Insert" click event routine via command button. I have a Structured table called "myTable" with a variable number of columns (they represent the names of the districts); The Header Range has the name "DistrictHeaderRange"; I have a form with...
  11. S

    Using listobject name reference in chart series issues after update

    Hello! I've encountered very weird behavior of Excel after latest update (semi-annual channel). Everything was working perfectly for over a year now. I've created addin (VBA), that creates charts automatically from pulled SQL data. I used following format for series data definition: SERIES...
  12. R

    Need help on code to copy formula from one cell to other cells in the row on a dynamic table

    Hi All, I am still learning VBA and currently, I am stuck on how I can copy formula from cell(1,1) on a table to new rows when the table expands (or new columns are added). Here's an example of my setup: Table1: PricesPerFruit <tbody> Fruit Price apple 1 pineapple 2 grapes 3 </tbody>...
  13. N

    Paste data from old listobject to new

    I am trying to paste data from old listobject to a new listobject and have come with this sub: Sub san_import(owb As Workbook, nwb As Workbook, sha As Worksheet, lis As String, col As Long, res As Long) Dim orng As ListObject Dim nrng As ListObject Dim r_fix As Long Dim c_fix As Long With...
  14. N

    Check if two Listobjects are same size

    I am trying to develop a macro where I will be importing values from one Listobject to another Listobject. Before pasting the values, I need to ensure that the two Listobjects are the same size, i.e. they have the same number of rows and columns. If this is not the case, then the "new...
  15. N

    Check is a single row in Listobject is selected

    I am looking for a way to check if the user has selected a single cell or single row within a Listobject. If this is the case, then I would like to return the value from Column 1 of the Listobject for the particular row. Not sure how to start with this one. any help is much appreciated. many...
  16. J

    Excel VBA Current Table Name

    Hi, I have a Worksheet with multiple Tables, how can I find the Table Name of the Table I'm currently in? Everything seems to point to ListObject(1) but I don't know which ListObject Number it is. Any help appreciated :)
  17. AOB

    VBA to flatten tables (ListObjects) to ranges (XL2013)

    Hi everybody, I need some code to convert all tables in a workbook to "flat" ranges (that is, retain the data, just get rid of the table structure around it) I thought this would be fairly straightforward : Public Sub FlattenTables() Dim sht As Worksheet Dim lso As ListObject For...
  18. T

    Immutable identifier for ListObject

    Is there any way to get an immutable identifier for a ListObject? A ListObject has a Name and Index property and belongs to a parent worksheet, but suppose I have a ListObject called 'Table1' and then I delete that table and then add a new ListObject also called 'Table1' that also has Index=1...
  19. A

    Get unique values from table (Listobject) and import to another Table

    Guys, i m trying to get the unique values from excel table (declare as listobject) and import them to another table (declare as listobject).the issue is that when a paste the values ,the first two values are the same and the table don't resize. Code posted below...
  20. A

    UDF Returns #Value with Table Reference

    I have been trying to make a UDF to return salary based on various factors (COLA/Location, Job Title, Performance, etc). I have been running into issues incorporating ListObjects and assigning them to Ranges. I have looked at other forums and I don't know if this is possible, but I have tried...

We've detected that you are using an adblocker.

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.
Go back
Back
Top