|
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 -- peterbarone ------------------------------------------------------------------------ peterbarone's Profile: http://www.excelforum.com/member.php...o&userid=28068 View this thread: http://www.excelforum.com/showthread...hreadid=475812 |
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" wrote in message ... 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 |
Golf League Help
|
| All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com