Windows 7 Autofill error in macro

[bk77]

We have recently upgraded to Windows 7 and a previously written macro is now encountering an error.

The macro determines the unique values in column AG and then totals them at the bottom (note that the values in AG can be repeated numerous times). However, if there is only 1 unique value in AG, the macro is getting confused and returning a 1004 error. As I have this macro cycling through a book with nearly 100 pages, this is proving to be a pain.

Please see code below and thank you in advance.

Please Login or Register  to view this content.

[bk77]

bump - I have done a few searches for solutions and haven't been able to implement successfully.

[shg]

Please Login or Register  to view this content.

[bk77]

works like a charm. Thank you!