Need greenup.xls until row 70 in excel.

[ferryfh]

Hi Gary,

I need some additional greenup.xls until cover for row 70 in excel, specially for column Greened Up P&L (AB), i have some strategy to compare 1x2 match odd vs Asian Handicap, this asian handicap need until row 70.

I'm very appreciate if you can do this for me and members.

Thank you,
ferry

[Captain Sensible]

Just amend the sheet you've already got don't think you need to do anything else other than change the line

For r = 5 To 50

to

For r = 5 To 70

In the vba coding, open the sheet press ALT+F11 together to open the VBA editor, double click the line of the left hand side that shows as sheet1 to open up that coding. Scroll down to the Private Sub calcGreenUp() coding and amend the 50 to 70 in the For r = 5 To 50 line of code and you should be done.