Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. 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
  2. Thread: attendance list

    by fburg
    Replies
    5
    Views
    232

    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...
  3. Thread: attendance list

    by fburg
    Replies
    5
    Views
    232

    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...
  4. Thread: attendance list

    by fburg
    Replies
    5
    Views
    232

    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...
  5. Replies
    7
    Views
    240

    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...
  6. Replies
    3
    Views
    144

    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
  7. Replies
    6
    Views
    739

    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...
  8. 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,...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. Replies
    13
    Views
    602

    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....
  16. Replies
    13
    Views
    602

    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
  17. Replies
    13
    Views
    602

    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...
  18. Replies
    13
    Views
    602

    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...
  19. Replies
    13
    Views
    602

    When I said no VBA, I meant no VBA in the...

    When I said no VBA, I meant no VBA in the workbook that I make available.

    But no one is inputting an infinity symbol. As I mentioned in my response to Martin, the infinity symbol is part of an IF...
  20. Replies
    13
    Views
    602

    Thanks Martin. As an example, consider the...

    Thanks Martin.

    As an example, consider the following formula:
    ="The range of the function is " & IF(a>0, "yv, " & infinity, "-" & infinity & ", yv")

    Instead of infinity, I want the single...
  21. Replies
    13
    Views
    602

    characters w/ different fonts in a cell

    Hi,

    I searched the Internet and found several posts that say I can't do what I'd like.

    I have a formula that returns one of two strings. Within each string, I'd like the infinity symbol. The...
  22. Replies
    11
    Views
    641

    Hi Martin, That was what I tried to do with...

    Hi Martin,

    That was what I tried to do with SUMIF when I posted my alternative "elegant" solution. Couldn't get SUMIF to work with a criterion using ISNUMBER(). Something like...
  23. Replies
    11
    Views
    641

    Not sure how elegant this is but how about {...

    Not sure how elegant this is but how about

    { =SUM(IF(ISNUMBER(range),range,0)) }

    where the braces are from entering the formula as an array formula with CTRL+SHIFT+enter

    I tried using SUMIF...
  24. Replies
    31
    Views
    1,515

    Hi Maud, Per my post to K32, I provided...

    Hi Maud,

    Per my post to K32, I provided another solution for consideration.

    It sounds like what you did for K32 might be something I'd like to consider for my problem (see the email to K32 with...
  25. Replies
    31
    Views
    1,515

    Hi K32, It seems like Maud and you have...

    Hi K32,

    It seems like Maud and you have iterated quite a bit and must be close to a solution. I'm sure I'm jumping in a bit late.

    But last year, I had a similar problem and found a non-VBA way...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4