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

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

--
peterbaron
-----------------------------------------------------------------------
peterbarone's Profile: http://www.excelforum.com/member.php...fo&userid=2806
View this thread: http://www.excelforum.com/showthread.php?threadid=47581