Search results for query: *

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

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

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

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

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

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