Macro problems with golf score calculator

[Catalpa]

I use a spreadsheet to calculate the net scores & stableford points for our golf outings. The macros that create the leaderboards for the 3 different categories for high, mid & low handicaps is not pasting all the info correctly and I can't see the problem in the VBA code. can anyone please help?
GOLF SCORE CALCULATOR.xlsmThanks in advance

[ragulduy]

Try this (it's one macro for all three sheets).

Please Login or Register  to view this content.

[Catalpa]

Hi ragulduy
I copied and pasted the code into the 3 modules and an error message appeared with "cannot run the macro GOLF SCORE CALCULATOR TEST.XLS. The macro may not be available in this workbook or may be disabled"

Thanks

[ragulduy]

Hi,

You only need it once in one module.

[Catalpa]

Hi again,

I deleted two of the macros & inserted the code into the remaining module and it still doesn't work! What am I doing wrong?

[ragulduy]

Hi,

please see attached example.

[Catalpa]

Thank you so much ragulduy. Much appreciated. Apologies for delay in replying. I was away on holiday
Thanks again