listrows

Hi all, I have the following code: If Not Intersect(Selection, ActiveSheet.ListObjects(1).DataBodyRange) Is Nothing Then<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Dim CopyRownr As Long CopyRownr = ActiveCell.Row -...

Hi all, I have 3 tables on a sheet and I'm trying to reference a ListRow. I'm using .find to find an empty cell in the 3 tables and the row number - the ListRow number of that cell is what I would need.. but I get the actual row number and then Subscript out of range.. could someone help me...

HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...

I'm at wits end... I have two ActiveX control buttons on a Worksheet ("Servers_Test"): btnAddWindowsLinux and btnDeleteWindowsLinux. Here are the following VBA macros, respectively: Option Explicit Private Sub btnAddWindowsLinux_Click() Dim servers As Worksheet Dim serverTable As...

Has anyone ever run into this problem before? I have an extensive .xlsm which uses the simple command line : ThisWorkbook.worksheets(1).listobjects(1).listrows.add And 2 out of 3 times, it will cause a run-time error which will then crash Excel and restart it. The full piece of code is as...

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

I try to delete all the rows in my table. I would be preferable not to delete the entire row, but only the in the table, but I guess it's not possible. When I use the code below it does what it should but ends with an error "Run-time error '1004': Application-defined or object-defined error"...

I create new rows to a list in Excel 2007 by this Dim objNewRow As ListRow Set objNewRow = Selection.ListObject.ListRows.Add(AlwaysInsert:=True) When i want to put in some information in my newly inserted row i use the Cells object. objNewRow.Range.Cells(1,1).Value = "John Doe"...