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