listobject

  1. 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 =...
  2. 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...
  3. 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...
  4. 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>...
  5. 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...
  6. 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...
  7. 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...
  8. 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 :)
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. R

    searching an cellvalue in listobject depending on 2 search criteria

    Hello together, i am new here and i hope that someone with deeper Excel VBA knowledge can help me out with my problem. I got an Listobject (see my example below) where i have some data. To be specific it has the columns year, week and value. I need to write a function in VBA which has the...
  14. O

    VBA: creating name for ListObject column range fails when it's in "A1"

    Hi, I want to create a name for the data range of a given table column, using the syntax "Table[Column_name]", so that if the table moves, expands, shrinks, is renamed, or reorder columns (...), the range referred to by the name is still correct (per opposition to use the range address syntax...
  15. S

    Relative referencing with structured table references

    Hi all, While writing out the title for this posting, it occurred to me how much it sounds like an oxymoron... but I am going to go ahead and post anyway in search of an answer. I have a ListObject (table) that contains two columns like the sample below... <tbody> Footage Length 0 =100 - 0...
  16. S

    Copy from wb2 and paste into ListObject in active workbook

    Hi. I get an IE generated report once a week. I want to copy cells A4:E4 to the last value in those columns from this workbook (report.xls), from worksheet (report) and paste them into Table1 of the active workbook. What I have tried so far always overwrites the Table and ends up converting...
  17. S

    Excel ListObject doesn't update on adding new item in data source.

    Hi, I am working on vsto addin which uses ListObject to create table. This ListObject is binded to a List<> collection and the data shows up fine. The problem is, when user adds a new row in the table by using Right Click->Insert->Table Row Above/Below, It does not add a new entry in datasource...
  18. H

    Cell references of range and listobject differ, looking for explanation and solution.

    I am trying to loop through the cells of several copied listobjects (table) in a workbook The problem I run into is that the cell references of the "(each) cell loop" are different from the listobject.range.cell/row references, and equal to the offset/references of the first cell of the...
  19. D

    Refer to multiple columns in a listobject (VBA)

    I know it's probably really simple and I'm just being a bit thick, but how do you refer to more than one column in a listobject in VBA??? So I have a listobject with 6 columns, and I want to do a vlookup to look at columns 3 to 6. I have googled and googled but can't find an answer! Thanks :)
  20. L

    Getting a range data of a column from Excel 2016 through VBA

    Hi, I am trying to get a range of data from a column of my Excel sheet on VBA, and then process each cell of the column one by one. By there is a run time error "Subscript out of range" while getting the ListObject. Could you please let me know what this wrong with the code and who can I...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top