Search results for query: *

anyone know? If you have a function as follows: =If(A1=B1,CountA(C1:C1000000),Sum(D1:D1000000)) when excel performs a recalc does Excel recalc both the true and the false portions of the statement or is it the same as the creating your own User Definied Function and only recalcs the True or...

you could use the RANK() function to establish the frequency of the values in the population.

Hey, I have created an outlook custom form and distributed it to users, each time the email is opened the message box asking the user to enable/disable macros pops up. I have changed my Macro security settings from Medium to Low but this always switches back to medium as soon as i try opening...

Excel 2007 but can move to Access 2007 if necessary.

Hi All, Required: VBA to create instance of Internet Explorer (already done works) VBA to open URL, in this case Facebook users profile (ok done, works) Click like button or Add friend button in facebook? (not found solution yet) Cheers M

ta

Hi All, The following line doesn't seen to work Sub mdl_GetData() Application.Run ("'my workbook.xls'.'my sheet'!cmdBtn_Click") end sub Several things causing issues here: 1 there are spaces in the workbook name 2 there are spaces in the sheet name 3 the code I need to run is held within a...

if the conditional formatting needs to be copied down to a defined range you might think of using the R1C1 format of cell referencing rather than using A1, to chenge this go to Tools options and change the setting in there. For the cell to the left of the current cell this would be...

Please help, I am opening Excel from Access and need to resave the file with another name. Problem is not seeming to work at the moment. Please advise... Pabs Public Sub mdl_OpenSS(myDir As String, myFile As String, myProcessID As Integer) Dim myCurDir As String On Error GoTo myError...

Hi Skip, We both have full access to the same network location. He has manual calc set with reclac on save switched on, if I have the same we still get the same scenario. Any other thoughts? otherwie we shall create a messy workaround? Cheers Matt

hello, Getpivotdata (GPD) is causing me soem issues. On my pc GPD function is linked between two files. When close the file containing the pivot and save the file containing the GPD function the result is retained. HOWEVER! on a colleagues pc when the above is actioned to the letter, the...

Has the macro got a step where a filter is applied and then the visible rows are deleted? 2003 does not work so well with this. Can you post the code? Cheese Matt

ColA ColB ColC ColD a 1 =COUNTIF($A$2:A2,A2) =+A2&C2 b 2 =COUNTIF($A$2:A3,A3) =+A3&C3 c 3 =COUNTIF($A$2:A4,A4) =+A4&C4 d 4 =COUNTIF($A$2:A5,A5) =+A5&C5 e 5 =COUNTIF($A$2:A6,A6) =+A6&C6 f 6 =COUNTIF($A$2:A7,A7) =+A7&C7 g 7 =COUNTIF($A$2:A8,A8) =+A8&C8 h 8 =COUNTIF($A$2:A9,A9) =+A9&C9 a...

Can anyone help me out. I currently have a query against 2 tables of data taking about 30mins to query. Not efficient I can hear you say, not able to do anything about it unfortunately. I need to extract one field from one record in a recordset of 33million records. Attempts so far include...

...Access;MaxBufferSize=2048;PageTimeout=5;", Destination:=Range("A1")) .CommandText = Array("SELECT * FROM TableName WHERE FieldName='" & Sheets(1).Range("A1").Value & "'") .Name = "Query from MS Access Database" .FieldNames = True .RowNumbers = False...

Approach from a slightly different angle... Sort the data in this order... Date Sort Descending Account Sort Ascending District Name Sort Ascending District ID Sort Ascending Area ID Sort Ascending then in cell F2 enter the following...

best option for you save the macro and word document in a development area as a normal word document. Save the macro and word document in a suitable network location as a document template. In word go to [tools]... [templates and add-ins]...[Add]... This creates a central macro which...

no surprises there then!

could possibly be editing a cell or running a macro at the same time as trying to change the filter? Matt

the dates required are in julian format, so by putting the real date into the datevalue function it is then converted into the julian date format required. Cheers Matt