Search results for query: *

Hi, I have a List (Listobject) in a worksheet, to which I wish to copy new data. Unfortunately it does not seem to be possible to paste the data when the number of rows in the copied data is larger than the number of rows in the existing list, or when trying to add a range of rows to the bottom...

Hi, Is it possible to change the item number of a list (ListObjects)? I now have 12 lists on one excel worksheet, but since I did not make them in sequence the item numbers are in a random order compared to the sequence on the sheet. I have to compare these lists to other lists in other...

Hi, I have a pivot table that is based on a list in a different workbook. Every month this workbook changes its name (new version) and the list changes in length. Since the source workbook changes, using a basic dynamic range is not an option. I therefore have to redefine the source data of...

Hi, I would like to ask the following: How do I detect in which row of a list (ListObject) a selected cell is? Purpose: I would like to enable the user to select a cell or row in a list and then they have the option of 2 buttons: Duplicate Row - the row gets copied and added at the bottom of...

Hi, I have an Excel workbook in which I use an autofilter. Some of the rows in the list always have to remain hidden. However, when I hide a row, or give it a height of 0, these rows reappear again if I use the Autofilter (All) selection or Filter-> Show All I also use VBA code to show all...

Hi, I am making an application that will be used by multiple users. I now have the difficulty that I am referring to a type library that is not standard included in Windows. On my own computer I have downloaded and installed BTXPPanel.dll so everything is fine, but when running the file on...

I was wondering how I can efficiently pass an array from one procedure to the other. VBA accepts the following: Public Sub Checksheet() Dim OmmissionArray(1 To 14, 1 To 8) As Integer '......some stuff to fill the array CompleteOmmissions OmmissionsArray:=OmmissionsArray End Sub Public Sub...

Hi, I am having some difficulty with unprotecting worksheets. I have a procedure that should unprotect all worksheets in the workbook (about 10 sheets), but sometimes not all worksheets are then unprotected, it either skips sheets, or stops at a certain sheet. I'm not sure what is different in...

Hi, I would like to run through a column of a list (ListObject) in my Excel sheet to check the value which is in it, in order to find out what the highest number is in the list. How can I point to a certain cell in a list and read its value? I now have something like this (unknown code marked...

Hi, Situation: I have build an elaborate spreadsheet which will be shared by several people. In this one can select a month (written out: January, February etc.)and a year from two validation lists. I have then used the DATEVALUE function to convert these parameters from the two cells into a...

Hi, Situation: I have build an elaborate spreadsheet which will be shared by several people. In this one can select a month (written out: January, February etc.)and a year from two validation lists. I have then used the DATEVALUE function to convert these parameters from the two cells into a...

Hi, I am having trouble calling procedures in a different workbook. From a Sub in Workbook1, I want to run the procedure Public Sub Test() in Module1 of Workbook2. Workbook2 is already open. What should be the code for this? Thanks! Nicolaas