Run-time error '1004' - Select method of Range class failed

[g10drac]

Hi,

I am getting this error when I run my (below) macro from a button. When I run the macro by itself (not via button), I don't get the error. I am using VBA in Excel 2007.

Please Login or Register  to view this content.

Any clues as to what I may have done wrong.

[TMS]

Welcome to the forum. In future, please use code tags around your code.

I've changed it for you this time.


What sheet is selected when you run the code from the button?

Try:

Please Login or Register  to view this content.

Regards