Spreadsheet macro stopped working!

Hi,

I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:

Scorecard, statistics, database and equations (for calculating some
specific).

I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for par3, par4 and
par5 holes. This worked perfectly, until now!

If I click "Save scorecard" the database is updated, but the statistics
page is messed up.

The macro should just copy the scorecard matrix (M39:O48) and add the
values to the statistics matrix (AB3:AD12), and copy scorecard matrix
(P38:R48) and add the values to statistics matrix (AG3:AI13). However,
when hitting "Save scorecard" the matrices on the statistics sheet
suddenly contains information like this:

=0+(COUNTIF(AG1048553:AG1048574;5))

This should just read a number (0 in this case). Also many of the
entries are now listed as #### or #REF! Looking at the entry itself gets
you information like this:

=2+(COUNTIF(#REF!;4))

This entry from the example above should only read 2.

The macro that copies the matrices looks like this:

Sheets("Scorecard").Range("M39:O48").Copy
Sheets("Statistics").Range("AB3").PasteSpecial Operation:=xlAdd
Sheets("Scorecard").Range("P38:R48").Copy
Sheets("Statistics").Range("AG3").PasteSpecial Operation:=xlAdd


Any ideas on what's gone wrong here?

Anders

Sorry, forgot to say that it's Office 2007

Anders

No one with an idea?

When replying to your own post it would be best to include the original text
in your reply.

Or cite the message ID of your original post.


Gord Dibben MS Excel MVP

On Sat, 21 Nov 2009 09:45:35 +0100, Anders wrote:

No one with an idea?

Trying again. Anyone with an idea???

Anders skrev:
Hi,

I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:

Scorecard, statistics, database and equations (for calculating some
specific).

I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for par3, par4 and
par5 holes. This worked perfectly, until now!

If I click "Save scorecard" the database is updated, but the statistics
page is messed up.

The macro should just copy the scorecard matrix (M39:O48) and add the
values to the statistics matrix (AB3:AD12), and copy scorecard matrix
(P38:R48) and add the values to statistics matrix (AG3:AI13). However,
when hitting "Save scorecard" the matrices on the statistics sheet
suddenly contains information like this:

=0+(COUNTIF(AG1048553:AG1048574;5))

This should just read a number (0 in this case). Also many of the
entries are now listed as #### or #REF! Looking at the entry itself gets
you information like this:

=2+(COUNTIF(#REF!;4))

This entry from the example above should only read 2.

The macro that copies the matrices looks like this:

Sheets("Scorecard").Range("M39:O48").Copy
Sheets("Statistics").Range("AB3").PasteSpecial Operation:=xlAdd
Sheets("Scorecard").Range("P38:R48").Copy
Sheets("Statistics").Range("AG3").PasteSpecial Operation:=xlAdd


Any ideas on what's gone wrong here?

Anders

You can send the workbook to my email address and I'll take a look.

gorddibbATshawDOTca change the obvious.


Gord Dibben MS Excel MVP

On Sun, 22 Nov 2009 08:54:17 +0100, Anders wrote:

Trying again. Anyone with an idea???

Anders skrev:
Hi,

I recently made an Excel spreadsheet for keeping track of my golf score.
The spreadsheet is quite simple. It consists of 4 sheets:

Scorecard, statistics, database and equations (for calculating some
specific).

I insert informations about the golf course I'm playing and how my score
was etc. I then hit a button "Save scorecard" that runs a macro. The
macro inserts specifik values from the scorecard into the database sheet
(which works like a charm). The macro also updates the "Statistics"
sheet with information about stroke number and points for par3, par4 and
par5 holes. This worked perfectly, until now!

If I click "Save scorecard" the database is updated, but the statistics
page is messed up.

The macro should just copy the scorecard matrix (M39:O48) and add the
values to the statistics matrix (AB3:AD12), and copy scorecard matrix
(P38:R48) and add the values to statistics matrix (AG3:AI13). However,
when hitting "Save scorecard" the matrices on the statistics sheet
suddenly contains information like this:

=0+(COUNTIF(AG1048553:AG1048574;5))

This should just read a number (0 in this case). Also many of the
entries are now listed as #### or #REF! Looking at the entry itself gets
you information like this:

=2+(COUNTIF(#REF!;4))

This entry from the example above should only read 2.

The macro that copies the matrices looks like this:

Sheets("Scorecard").Range("M39:O48").Copy
Sheets("Statistics").Range("AB3").PasteSpecial Operation:=xlAdd
Sheets("Scorecard").Range("P38:R48").Copy
Sheets("Statistics").Range("AG3").PasteSpecial Operation:=xlAdd


Any ideas on what's gone wrong here?

Anders