listobject

How can I reference the listobject when I copy the worksheet within the workbook? For example: MyTable is the current name of the listobject in the worksheet MyWorksheet.

I have a Table, with 144 columns, consisting of strings that I convert to Formulas in another Table. Work around for Volatile function Indirect when I add and remove Sheets, but need the Formula NOT to go #REF.... SO - I have an 1 dim array and would need each data to be written/saved in a new...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 :)

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

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