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.