+ Reply to Thread
Results 1 to 3 of 3

Golf League Help

  1. #1
    Registered User
    Join Date
    10-13-2005
    Posts
    2

    Golf League Help

    Hello I'm new here and I'm sorry if I'm posting in the wrong place.

    I was wondering if someone could help me with this macro
    ///Sub handi1()
    '
    ' handi1 Macro
    ' Macro recorded 10/6/2005 by House of Vacuums
    '
    ActiveCell.Offset(0, 1).Range("A1").Select
    ActiveCell.FormulaR1C1 = "='week 1 matchs input'!RC-1"
    ActiveCell.Offset(0, 1).Range("A1").Select
    ///End Sub

    The macro it self works I made 26 of them ( for the players hadicaps) they all work.

    Where I messed up is they only work on "week 1" I have 16 weeks to do

    What can I change the ActiveCell.FormulaR1C1 = "='week 1 matchs input'!RC-1"
    to make this work

  2. #2
    Gary Keramidas
    Guest

    Re: Golf League Help

    i have something i set up for my brother's golf league, if you're interested
    email me and i can send it to you.

    --


    Gary


    "peterbarone" <peterbarone.1wug6i_1129212320.6016@excelforum-nospam.com>
    wrote in message
    news:peterbarone.1wug6i_1129212320.6016@excelforum-nospam.com...
    >
    > Hello I'm new here and I'm sorry if I'm posting in the wrong place.
    >
    > I was wondering if someone could help me with this macro
    > ///Sub handi1()
    > '
    > ' handi1 Macro
    > ' Macro recorded 10/6/2005 by House of Vacuums
    > '
    > ActiveCell.Offset(0, 1).Range("A1").Select
    > ActiveCell.FormulaR1C1 = "='week 1 matchs input'!RC-1"
    > ActiveCell.Offset(0, 1).Range("A1").Select
    > ///End Sub
    >
    > The macro it self works I made 26 of them ( for the players hadicaps)
    > they all work.
    >
    > Where I messed up is they only work on "week 1" I have 16 weeks to do
    >
    >
    > What can I change the ActiveCell.FormulaR1C1 = "='week 1 matchs
    > input'!RC-1"
    > to make this work
    >
    >
    > --
    > peterbarone
    > ------------------------------------------------------------------------
    > peterbarone's Profile:
    > http://www.excelforum.com/member.php...o&userid=28068
    > View this thread: http://www.excelforum.com/showthread...hreadid=475812
    >




  3. #3
    Registered User
    Join Date
    10-13-2005
    Posts
    2

    Very intersted

    peterbarone@adelphia.net
    Last edited by peterbarone; 10-13-2005 at 12:28 PM. Reason: forgot my email

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1