Recent content by MJPPaba

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

Hi, In principle it is quite easy, If you record a macro and go through the process of importing a sample of the data you want to a worksheet ensuring you put in a criteria you can then go into the code and amend it to allow it to become more dynamic, e.g. With...