Search:

Type: Posts; User: grugeon; Keyword(s):

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    2,337

    Same issue - seems a bit rude excluding people on...

    Same issue - seems a bit rude excluding people on the basis of race (or country of residence)
  2. Replies
    5
    Views
    14,041

    Sorry - been a bit busy. If the workbooks are...

    Sorry - been a bit busy.

    If the workbooks are checked that will Prevent​ you opening them. Try unchecking everything and see how you go.
  3. Replies
    7
    Views
    1,140

    Quite right I should have said ...

    Quite right I should have said IF(DAY(B2)>13,B2,DATE(YEAR(B2),DAY(B2),MONTH(B2)) )

    Unless the OP tells us that he has solved it we have no way of knowing. He may be embarrassed to say that none...
  4. Replies
    7
    Views
    1,140

    Try this formula...

    Try this formula
    =IF(DAY(B2)>12,B2,DATE(YEAR(B2),DAY(B2),MONTH(B2)))
    then format the cell as date
  5. Replies
    5
    Views
    14,041

    You need to do some more research. 1. Can he...

    You need to do some more research.

    1. Can he save the file from the email?
    2. Can he open the saved file by double clicking it?
    3. Can he open the saved file by opening excel, and using...
  6. Have you tried to find out what is happening on...

    Have you tried to find out what is happening on your computer. Almost certainly you have a program running in the background which is taking up CPU cycles. open Task manager (Right click a blank...
  7. Replies
    2
    Views
    559

    I think you will need to do a separate chart. I...

    I think you will need to do a separate chart. I could not find any useful way to combine the two sets of data into one chart.
  8. Replies
    6
    Views
    758

    It depends on how you "Add lines", If you right...

    It depends on how you "Add lines", If you right click the number to the left of the row and click insert, it will insert a complete row with the same formatting as the row above. It also provides...
  9. Replies
    2
    Views
    1,528

    I think you need to modify the Footnote style.

    I think you need to modify the Footnote style.
  10. Replies
    33
    Views
    11,274

    Could you copy your exact formula and paste it...

    Could you copy your exact formula and paste it into a post so we can see if
    (A) it begins with =
    (B) it contains names which may be variables or ranges
    (C) if there is anything else weird about...
  11. Replies
    33
    Views
    11,274

    Try changing the format in the cell and then...

    Try changing the format in the cell and then changing it back again.

    find a cell which displays properly and copy it to the problem cell. Then retype (not paste) your formula.
  12. Replies
    2
    Views
    12,234

    Deletes or doesn't show?

    Possibly they are not deleted but just hidden. Try going to view/reset view. They may magically appear.
  13. Replies
    8
    Views
    807

    Try this I have included "(" and ")" as not...

    Try this

    I have included "(" and ")" as not significant but you can take them out if I have guessed wrong.

    You need to select the cells to be tested and then run the sub.


    Option Explicit
    ...
  14. Replies
    2
    Views
    441

    Unless the property lists are identical I would...

    Unless the property lists are identical I would probably use vlookup formulas to copy the info across, then copy and paste-values to lock it in.
  15. Replies
    6
    Views
    468

    Re: Calendar macro (Home, SR2)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    You could try this one

    http://www.french.ucla.edu/faculty/gans/vb_macros/calmac.htm
  16. Replies
    8
    Views
    1,291

    Re: Word as window in IE7 (IE7.0.5730.11)

    Many thanks. Just what i wanted.
  17. Replies
    8
    Views
    1,291

    Word as window in IE7 (IE7.0.5730.11)

    Hi all

    Since installing IE7, when I click a link to a word doc, it opens in a window in IE7 (with reduced functionality). I used to get it opening in a word window with full functionality. I...
  18. Re: Changes made which affect global template (XP Pro SP-1 w/Office 2003)

    Perfect. Thanks - what more can I say?
  19. Re: Changes made which affect global template (XP Pro SP-1 w/Office 2003)

    I have the same problem. Deleting the Data key solved it - I thought. Until I found that this process had unticked the "Prompt to save changes to normal.dot". When that was turned back on the...
  20. Re: Flag and task time (OL 2002 SP2 on Win XP)

    Thanks Mary. I did not see the unlabelled box for the time. I was trying to enter the date and time in the date box like you could in earlier versions. Problem solved.
  21. Flag and task time (OL 2002 SP2 on Win XP)

    How can I get Outlook to allow me to specify a time for reminders from flagged messages and tasks.

    I have tried to put the time in but just get a message "please specify a valid date and time" it...
  22. Replies
    1
    Views
    302

    Re: paste value parsing (Excel 2000)

    The text file probably has something diferent in the first or second row and this can throw Excel. A workaround is to open the text file with excel rather than pasting it. This wil open the parser...
  23. Replies
    5
    Views
    473

    Re: Template issues (2000)

    1. File names are file names. Just change the file name in explorer to Elegant Resume.dot or whatever. It must end in .dot otherwise it may not be recognised as a template. The elegant resume...
  24. Replies
    8
    Views
    484

    Re: Forms & Subforms (Access 2002)

    Try this

    I have moved the relationship diagram around - that make no difference to anything.

    I have created a form which does more-or-less what you want.

    It needs some further development as...
  25. Replies
    8
    Views
    484

    Re: Forms & Subforms (Access 2002)

    Ah. More info. In that case you will need the separtate price table but it will have a one to meny relationship, not one to one. (Many on the Price side). I would take out the duplicate info. ...
Results 1 to 25 of 352
Page 1 of 15 1 2 3 4