Recent content by RachieD

Hi - I am doing an email mailmerge in MS Word and whilst the font is all the same in the Word document the hyperlinks change from Verdana 9 to Times New Roman 9 in the version sent by Outlook. This looks a bit rubbish. Can anyone advise what I need to do...? Thanks! Rachel

Thanks for the advice - I have reposted it.

I have added labels to a scatter chart using the below macro but would also like to add leader lines. I am not very familiar with VBA and borrowed the code for adding the labels. Can someone please advise how to add leader lines also? Sub AttachLabelsToPoints() 'Dimension variables. Dim...

I have added labels to a scatter chart using the below macro but would also like to add leader lines. I am not very familiar with VBA and borrowed the code for adding the labels. I would appreciate it if someone could let me know how to amend this code to add in leader lines also. Sub...

Thanks guys - it worked when I pressed F2 and then enter... I will try the macro too... Regards Rachel

Hi - I am updating a workbook sent to me by someone else and the formulas I enter do not calculate but appear as text. It doesn't help if I change FORMAT CELLS from Text. I have checked TOOLS, OPTIONS, CALCULATION and that is set to automatic so I am at a bit of a loss as to why it won't...

Thank you so much....! That worked beautifully!! I do apologise for steering you both in the wrong direction earlier on. I think I confused myself!!! It should be against the law that both of you are so clever...! :) Rgds RachieD

Hi Geoff - thanks for your comments. This is what I am trying to do... Column A is populated by text. I want to categorise the entries into the following: INSIDE, OUTSIDE, PIPELINE. I want the formula to say: if it says Commit then it is INSIDE, if it says Inside then it's INSIDE, if it...

Thank you very much Geoff, that worked brilliantly!! Is it possible to use this in a nested IF statement too? I tried but got the message saying I'd used too many arguments... Thanks again!! RachieD

Hi Geoff - yes I did look in the help file before I posted the question and when I received the answer from Combo, but I am still not sure how to do it.... Any help on this would really be appreciated... Rgds RachieD

Thanks for your response Combo - however, I'm afraid to say I have no idea how to write this... could you please give me an example? Thanks a million!! RachieD

Hi - is it possible to use Wildcards in an If statement? For example, I want to say something like: if A2 contains "Commit" then it is an "Inside" deal; else it is a "Pipeline" deal but if I write the following =IF(A2="*COMMIT*","INSIDE","PIPELINE") and A2 looks like this: A2 this is a...

Perfect - thanks a million Glenn!! I've given you a star! Cheers RachieD

Hi - can you please advise how I can amend my formula to replace my vlookup #N/A errors with 0. Formula is =VLOOKUP(A7,ProductPivot!$A$3:$B$500,2,FALSE) I need to sum the results. TIA RachieD

Thanks very much everyone - your help was invaluable...!! Both xlbo and skipvought came up with the answer I needed - Skip it was calculated relative to FY05. Thanks again!! Cheers RachieD