Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NicolaasH

    Pasting into a List

    Unfortunately that is going to be too complicated for the people that will be using the sheet. I think I'll go for the VBA solution, although I might have some questions about that too. Thanks anyway! Nick
  2. NicolaasH

    Pasting into a List

    1) I have a download from an ERP system into Excel. It contains 23 columns. The number of rows varies, since more data is acquired over time. 2) I have an Excel workbook that contains a whole lot of data and worksheets where I manipulate this data. I have a separate worksheet to enter the data...
  3. NicolaasH

    Pasting into a List

    I believe I did mention that the pasting didn't work....It keeps on saying 'Select destination and press ENTER or choose paste' at the bottom of the screen, but neither does the job.
  4. NicolaasH

    Pasting into a List

    With some experimentation, I have found out that the problem lies in the fact that the list into which I paste contains a couple of extra columns. These columns contain formulas (date conversion, matching etc.) and I would like to keep them in there. Do you know whether there is a solution to...
  5. NicolaasH

    Pasting into a List

    I understand what you mean and I did just that- i.e. select the single top most cell of the list. When pasting it actually outlines (cells become selected/blue) where the new data should have come. It does not give an error message when pasting into the topmost single cell. There is an error...
  6. NicolaasH

    Pasting into a List

    I did that, (tried several things: top left cell, top row, insert row, column name row) nothing like that seems to work.
  7. NicolaasH

    Pasting into a List

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

    Indexing lists

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

    New source data for pivot table

    Skip, I don't get it yet, but thanks anyway. I have disgarded the whole idea and solved it differently (I now put everything in an array and with that make the grouping and comparison). Nick
  10. NicolaasH

    New source data for pivot table

    Skip, I have tried that, however, I do not seem to get it translated to usable code. The wizard returns the following: ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _ "'[WW Pipeline Axon January 2008 V5.xls]Pipeline'!R9C1:R297C52" However if I then change the...
  11. NicolaasH

    New source data for pivot table

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

    Selected row in a List

    I have found a solution, be it not a very aesthetic one. I have first determined the absolute row reference of the top of the list and than subtract this from the absolute reference of the selected cell. ListPosition = objList1.Range(1, 1).Row AbsoluteRow = ActiveCell.EntireRow.Cells(1, 1).Row...
  13. NicolaasH

    Selected row in a List

    Unfortunately it is a problem, because it is not merely copying and pasting. I need the ListRow reference to find a couple of other parameters (this happens in the 'rest of code bit, and the procedure AddRow that is called). To keep the code neat and not run into problems when I move the list...
  14. NicolaasH

    Selected row in a List

    Yes, I had something like this before, ActiveCell.EntireRow.Cells(1, 1).Row however this returns the row in the sheet, while I am looking for the row in the List, which is a different index different.
  15. NicolaasH

    Selected row in a List

    Bob, thanks, but could you help me out a little more? I'm not sure how to extract the index number yet, I guess that was actually my question. I now have the following code: Public Sub DuplicateRow() Dim ListWorksheet As Worksheet, objList1 As ListObject Dim SelectedRow As Integer Set...
  16. NicolaasH

    Selected row in a List

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

    Keep cells hidden when using autofilter

    Skip, I guess your anwer is: bad luck, there is no solution? The big deal is that I estimate it to be at least 3 hours work to change everything in different workbooks, worksheets and a whole lot of VBA procedures, while at the same time I thought I had finished my work.... thanks anyway Nick
  18. NicolaasH

    Keep cells hidden when using autofilter

    The first row in the List is hidden because it has default information that I copy to new rows (using VBA). I realise that I could have placed this information somewhere else, but changing this now is a lot of work (code adaptation). Unfortunately I only just found out that these rows become...
  19. NicolaasH

    Keep cells hidden when using autofilter

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

    Type Library Reference (BTXPPanel)

    Hmmmm, no doesn't help. The weird thing is that if I do not have this file installed I (and other users) get the message: Compile Error: Can't find project or library and it highlights the Chr(10) method in the code below. I cannot remember how I found out that installing the BTXPPanel...

Part and Inventory Search

Back
Top