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
Bookmarks