sorry, the answer is activating the sheet before that line:

Sheets("ABC").Activate

i did the search but with "sheeeet" in the search-box, sorry :)

"darxoul" wrote:

I have this line in my macro:

Worksheets("ABC").Columns("A:A").Select

If I run this macro when I am in a different sheet, it gives the run-time
error 1004. How can I avoid this? What is the reason?

Thx in advance.