Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    2
    Views
    47

    Thanks Paul. 1. If I clear the entries (set...

    Thanks Paul.

    1. If I clear the entries (set the field in all conditions to "None"), all records are shown in the Edit Recipients list, so no need to select "All". Oh well.

    2. OK. At the risk of...
  2. Replies
    2
    Views
    47

    Word 2003: Mail Merge SQL Expanding

    Hi All,

    I've run into something which MIGHT be a problem although there is an "unacceptable" workaround.

    I have an Excel spreadsheet that serves as a data base for a mail-merge. Each row...
  3. Mike, Put -1 in some empty cell. Copy it to...

    Mike,

    Put -1 in some empty cell. Copy it to the clipboard.

    Now select the cells that are negative that you want to change. Next go to Edit | Paste Special. At the bottom, click the button for...
  4. Thanks Rory. Enjoy London and the blue skies....

    Thanks Rory.

    Enjoy London and the blue skies.

    Fred
  5. Thanks Rory. Didn't know about Ctrl+Shift+End in...

    Thanks Rory. Didn't know about Ctrl+Shift+End in Excel.

    But still not sure about what to do once I've selected that cell. I tried a quick experiment. If my hypothetical V258 is truly my last cell,...
  6. True. But suppose there is some non-visible...

    True. But suppose there is some non-visible character 500 rows below the actual last cell and lots of columns to the right.

    If one "knows" the last cell (I know there is nothing beyond V258 let's...
  7. Thread: If statement

    by fburg
    Replies
    9
    Views
    264

    [SOLVED] Cool? It's very cool! I'm always writing OR...

    Cool? It's very cool!

    I'm always writing OR statements where I repeat the cell within the parens. Using the {set} braces (or array braces) is very cool.

    Fred
  8. Maud, Trying to run either graph gave a VBA...

    Maud,

    Trying to run either graph gave a VBA error "Unable to set the XValues Property of the Series Class" in the first ActivateChart statement of the Plot Data loop.

    Fred
  9. Thread: attendance list

    by fburg
    Replies
    5
    Views
    254

    OK - the issue is now resolved. Excel can't...

    OK - the issue is now resolved.

    Excel can't handle this in the way she wants - seems the same conclusion is true regardless of Apple or Windows platforms.

    She had used a spreadsheet called...
  10. Thread: attendance list

    by fburg
    Replies
    5
    Views
    254

    Thanks to all who gave us some good thoughts. ...

    Thanks to all who gave us some good thoughts.

    My friend has an appointment at the local Apple store today, so we'll see what happens.

    TD-no we didn't run that simple test but it may be...
  11. Thread: attendance list

    by fburg
    Replies
    5
    Views
    254

    attendance list

    Hi All,

    A friend of mine runs a dance school where, of course, attendance needs to be taken. She had an Apple-based spreadsheet (Numbers) last year that allowed her to put in checkboxes (no VBA or...
  12. Replies
    7
    Views
    289

    Hi Jimmy, I'm not quite following the...

    Hi Jimmy,

    I'm not quite following the situation. I do understand about number bases and how to convert between them, although I've never used base-32.

    First, if you've entered a base-16 number...
  13. Replies
    3
    Views
    157

    building on Paul's post: in H149, enter:...

    building on Paul's post:

    in H149, enter: =IF(ISERROR(MATCH(F8,$A$1:$A$3,)),"not found","found")

    and fill down to h179.

    Of course, you can change the messages in the IF test.

    Fred
  14. Replies
    6
    Views
    776

    Mac, What was described by cmptrgy and maudibe...

    Mac,

    What was described by cmptrgy and maudibe will work. Make sure you make the selection as suggested. But just one little thing to watch for in case it happens: if Excel thinks you're only...
  15. Yes - the display of the series before the loop...

    Yes - the display of the series before the loop followed by the definition of the series in the loop is what I meant by erasing. I get it - the series is defined before the loop for the whole range,...
  16. Thanks Steve. I don't know that much about...

    Thanks Steve.

    I don't know that much about charts, not much about VBA. So when you put the 2 together, my chart VBA knowledge is vanishingly small.

    Anyway, I put in a break at your setting of...
  17. Hi Steve, I'm not sure I see how the "old"...

    Hi Steve,

    I'm not sure I see how the "old" line graph is being erased in the code.

    More importantly, I noticed that the axes don't change. So, for example if one of the values goes beyond the...
  18. I think putting together some of the suggestions...

    I think putting together some of the suggestions in this thread (using Alt+Enter, wider columns) would be what you need. One addition: you can also include a &CHAR(nn) to concatenate a tab character...
  19. Hi RG Looks like you get around some. Nice...

    Hi RG

    Looks like you get around some. Nice seeing you over here too.

    I think the problem with PPT viewer will be two-fold - maybe only one and that's the important one.
    - these are...
  20. Want to run PowerPoint show in window then quit app

    I have 2 ppsx shows and noticed something bothersome. What I'm after is the "best" (for me) of both worlds.

    It seems like you can run a show in full screen mode (presented by a speaker); at the...
  21. To further what Zeddy said, boost your...

    To further what Zeddy said, boost your magnification to the max allowed (200% in Excel 2010). When you type the 3rd period, note the spacing between the periods. Now either hit Enter (to confirm the...
  22. Replies
    13
    Views
    666

    thanks Maud. I think I got the answer the...

    thanks Maud.

    I think I got the answer the first time around. Your original macro and/or the more recent one look to see if the infinity character code is embedded in the string of the target cell....
  23. Replies
    13
    Views
    666

    Per my response to your first VBA solution, does...

    Per my response to your first VBA solution, does this work only for a text string or can it be placed inside a formula as I asked?

    Fred
  24. Replies
    13
    Views
    666

    Hey RG, Maud, Not that I'm a member of the...

    Hey RG, Maud,

    Not that I'm a member of the Math Police but if you stretch the point, there isn't that much difference between tilde and infinity. Tilde is used in front of a number to mean...
  25. Replies
    13
    Views
    666

    Maud - Just noticed your "manual" suggestion. ...

    Maud - Just noticed your "manual" suggestion.

    At least in Excel 2010, the format menu item when right clicking the character is grayed out (as are most/all of the other useful formatting...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4