listobject

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

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

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

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

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

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

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

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

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

Hi, Hope someone can help I'm getting an error on the highlighted part of the code below? This occurs when I'm referencing a sheet by its code name and not its tab name. Any help or advance?? Private Sub CommandButton1_Click() Dim lngStart As Long, lngEnd As Long lngStart =...

Hello, I am looking for a code to find the name of a table that contains a specific cell value. Let me explain, I have a table that lists certain cell values. These values also occur in other tables in another worksheet. In my first table I want to add the table names of the tables in the other...

Hello, ODBC on Excel files makes it possible to access a WorkSheet as if it was a table in a database. This is done by naming the table with square brackets and a dollar, like this: SELECT customer FROM [Sheet1$] . What I really would like to do is accessing a ListObject as if it was a...

hi, i am filtering a listobject and passing some of its columns to a UDF called from a cell. the function is supposed to return only the filtered visible cells from those listcolumns. However it returns the whole range. i have posted the details here: excel - selecting...

Hi, I created a workbook which has 2 worksheets. Sheet1 contains a Students ExcelTable. Sheet2 contains a Teachers ExcelTable. I am trying to filter records in the Students Table using the following macro. When running the macro with Sheet1 active, the filtered range, rng2 is $A$1:$B$2 as...

I'm loading data from a list object into memory with Dim vtArray as Variant Set vtArray = ActiveSheet.ListObjects(1).DataBodyRange Can I choose a more efficient data type than Variant? I need to set the value of one of the columns to 0 in all rows. I can do this with Let...

Let us imagine that in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap...

Hello, I have a listobject (MyTable) situated above a larger dataset (= more columns) on a worksheet. This MyTable gets cleared and its databodyrange removed by either a macro or a manual delete. Normally in order to reset the databodyrange I would write: MyTable.ListRows.add (1) However...

Hello All, New user of Excel 2013 here. I have been trying my best to work out a userform which would feed information into a table. This is a simple example Im creating in order to apply it to a much more complicated model which I'll have to design. I named the table "NamesTable" and it...

Hi I'm new to using List Objects and Query Tables in VBA, and have been using some of the many tips I've found through Google, but I'm a bit stuck now. I am writing some VBA to: check if a List Object Query Table already exists if it doesn't, I want to create it using passed SQL and...

What is the best way to adjust the width of each column in a ListObject to the maximum length of its content? Currently the column width seems to correctly fit the name of the column but the contents just spill outside. I see a ListObject.QueryTable.AdjustColumnWidth but that is supposedly true...