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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: CWalsh87
  • Content: Threads
  • Order by date
  1. CWalsh87

    Sorting Pivottable by vba not working

    Hi, I'm using the following code to sort a pivottable: Me.subfrmDeliveries.Form.PivotTable.ActiveView.FieldSets("Prom Date").Fields("Prom Date").SortDirection = plSortDirectionAscending I'm happy the code is correct, but the pivottable is not sorting correctly, it's sorting by the "PO...
  2. CWalsh87

    Adding Recordset to array then filter pivottable based on array

    Afternoon, Apologies I have posted this in another section of the forum, but was advised to move it, i'm not trying to spam! Basically what I am trying to do is enter a value into a listbox (value is stored in a table) add these values into an array, then update a pivot table based on the...
  3. CWalsh87

    Adding listbox to array

    Afternoon, Basically what I am trying to do is enter a value into a listbox (value is stored in a table) add these values into an array, then update a pivot table based on the values in the array. I can add the items to the listbox / table. This works fine. I can filter the pivot table based...
  4. CWalsh87

    Pivot Table: Filter from Array

    Hi, I'm really having problems with this and looked all over for an answer. I have a pivot table in a form, with a list box (based on a table). I want to be able to click a button and the pivot table to be updated based on the values in the listbox. What I have done is create and array from...
  5. CWalsh87

    Excel VBA inserting unwanted quote marks!

    Hi, I need to insert a function into cells using VBA. For various reasons i need a variable in the function so i've used the following code: For a = 1 to 10 activesheet.range("D1:D100").select Selection.FormulaR1C1 = "=IF(ISERROR(SEARCH('Product Type'!D" & a & ",rc[1],1)),"""",'Product...
  6. CWalsh87

    FormulaR1C1 Help Please

    Hi, this is my first post on the forum, although the forums been very helpful over the last few months. I have however searched and cannot find an answer to my question. I have some VBA code which inserts a formula (using FormulaR1C1) into a cell. the problem is, the formaula is getting...

Part and Inventory Search

Back
Top