Worksheet change event copy column error

[ricklou]

I have a workbook with 2 sheets HistoryD and HistoryDD ....I have the following code to copy Column A-G from HistoryD to HistoryDD if any value is changed on B2-G2 -but when I change a value the macro thats been called have a n error about the range "Select error of range failed"...it complains about this line Range("A1").Select . Rep given for solution as its done with the macro recorder but its not running through ....What must be changed in the code ?? Thank you

Please Login or Register  to view this content.

[Keebellah]

The problem is that you're switching sheets and that is not allowed with events, you have to approach it differently. Not inside a worksheet module

[ricklou]

The problem is that you're switching sheets and that is not allowed with events, you have to approach it differently. Not inside a worksheet module

Thanks i fixed it

Please Login or Register  to view this content.

[Keebellah]

Good, glad you solved it