Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    298

    Re: handicap2 (excel 2007)

    Thanks Hans.
  2. Replies
    2
    Views
    298

    handicap2 (excel 2007)

    Attached jpg of a vb that HansV wrote a little time ago - XferRatings.

    Is it possible to change the value of Range("BF"...... by UserInput to any Range as required. e.g "BG", "CA" . etc ?
  3. Replies
    12
    Views
    778

    Re: handicap (excel 2003)

    By Crikey - Hans, that was a quick and very helpful reply.

    This old bloke -"haringkop uit Vlaardingen" - would have no chance of working that out.

    On ye mate!

    Cheers
  4. Replies
    12
    Views
    778

    Re: handicap (excel 2003)

    Hans, thanks for the macro. the IFERROR is now I(ISERROR.... etc.).
    Still I have a few more question:

    Cells U21:U24 and U26:U29 give me new ratings for teams A and B. These values are...
  5. Replies
    12
    Views
    778

    Re: handicap (excel 2003)

    Thanks Hans. I went out and bought a John Walkenbach's book - "Favorite Excel 2007 Tips @ Tricks" and as you explained the iferror is new to 2007!

    You are right I can get the values from line 1,...
  6. Replies
    12
    Views
    778

    Re: handicap (excel 2003)

    Sorry about the 2007.
    I have saved it as a 2003 file. Hope this helps.
    So much for me tinkering (and learning) with Excel.

    Cheers
    Cees
  7. Replies
    12
    Views
    778

    Re: handicap (excel 2007)

    Hans,

    Attached a copy of the workbook.
    I am trying to get the data from lines 1, 2, 3, etc in the "input data table and match records" automatically to be calculated in the "output data -...
  8. Replies
    12
    Views
    778

    Re: handicap (excel 2007)

    Thanks Hans,

    Can I put a sample within the 100k?

    Cheers
    Cees
  9. Replies
    12
    Views
    778

    handicap (excel 2007)

    I am stuck with a handicapping program. I am not an Excel expert just an old bloke tinkering away!

    As per attached - I am trying to get Excel to read the data from lines 1,2,3,4 etc. into the...
  10. Replies
    177
    Views
    6,631

    Re: Five and four zeroes

    Congratulations Hans.
    A toast to you <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif...
  11. Thread: data (excel 2003)

    by Cees
    Replies
    3
    Views
    274

    Re: data (excel 2003)

    HUGE screenshot moved to zipped attachment by HansV - don't post images larger than 640 x 480 pixels, PLEASE!

    Hans,

    First of all thanks for your help. This is to help with coaching. there is no...
  12. Thread: data (excel 2003)

    by Cees
    Replies
    3
    Views
    274

    data (excel 2003)

    Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>

    In my last post, <post#=545044>post 545044</post#> I showed the plot on the xy chart - it works fine and thanks to all for...
  13. Replies
    7
    Views
    722

    Re: xy chart (excel 2003)

    I took me a while - happens when you get older - must the Big Cheese's wine cellar <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> , but it appears I have been able to put a graph in...
  14. Replies
    7
    Views
    722

    Re: xy chart (excel 2003)

    As a coach, I am using thexy chart as a "polar plot" for the position of lawn bowls.
    I can see the distance and angle from the Jack., whether the bowl has crossed the head (y-axis), are too short...
  15. Replies
    7
    Views
    722

    Re: xy chart (excel 2003)

    Thanks Hans,

    It is so obvious now. First reduce the size of the external perimeter and than resize the chart.

    Thanks nad Merry Christmas. Any snow? and skating yet?
  16. Replies
    7
    Views
    722

    xy chart (excel 2003)

    1. In my xy chart I get a lot of spare space around the chart which I like to eliminate and just have the chart area the same size as the chart without resizing. Is that possible?

    2. Can I rotate...
  17. Thread: FIVE!

    by Cees
    Replies
    27
    Views
    1,214

    Re: FIVE!

    I have seen his wine cellar and it was empty.................
    You guys and girls drove him to drink it that way.
    Ok, Ok, I helped him a little bit. <img src=/S/cheers.gif border=0 alt=cheers...
  18. Replies
    2
    Views
    263

    Re: various inboxes (2003)

    Thanks Leif. I'll have a go at that tomorrow.
  19. Replies
    2
    Views
    263

    various inboxes (2003)

    We (the mrs and I) have 3 email accounts at home. Is it possible to have the emails received go directly to an inbox associated with that account?
    If yes how do I go about it.?

    In advance -...
  20. Re: cannot start Microsoft Outlook (outlook 2003)

    Thanks Hans.

    It works!!!!

    My problem (outlook) started when my cousin from Holland (Alkmaar) visited for a week.
    He left for Alice Springs this morning.
    Good thing was that he brought Leidse...
  21. cannot start Microsoft Outlook (outlook 2003)

    I get this error:

    "Cannot start Microsof Office Outlook. Unable to open the Outlook window. The set of folders coult not be opened. The server is not available. contact your administrator if...
  22. Replies
    4
    Views
    882

    Re: colliding lawn bowls (xp)

    Thanks fellows for your help.

    All I now have to do is learning flash and incorporating it in my presentations. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> <img src=/S/read.gif...
  23. Replies
    4
    Views
    882

    colliding lawn bowls (xp)

    This might not be the right forum, however....

    I have made PowerPoint presention for coaching of lawnbowls.
    PowerPoint is limited as it cannot do collinding bowls etc.

    I have flash subroutines...
  24. Replies
    2
    Views
    942

    leaving a trail (PowerPoint xp)

    Today is the first time I am using PowerPoint to make a presentation on lawnbowls.

    I can get the bowl to curve from the mat to its resting place.
    Question is: Is it possible to show a "trail" of...
  25. Replies
    2
    Views
    492

    Re: excel to printing labels (excel 2002)

    Thanks Hans. I'll give it go tomorrow, Saturday.
    Right now it is time to turn of the computer (Mrs T will be happy)
    and watch some of the Rugby Union World Cup.(Mrs T might not be so happy...
Results 1 to 25 of 45
Page 1 of 2 1 2