Run Time Error '1004' with select function

[marius1304]

Hi guys,

I am trying to create a billing tool and I am writing macros to smooth the input steps for some of my colleagues.

Unfortunately, I am already failing when doing simple steps. I created a command button and want to switch tabs, select cell A1 and then want to go to the first empty row.
However, my code seems to be wrong and it marks the line with Range("A1").Select with the 1004 run time error.

Please Login or Register  to view this content.

I would be glad to get some responses for this topic.

Best
Marius

[daffodil11]

Sounds like you have cell A1 protected and it can't be selected.

[JOHN H. DAVIS]

I think your cell A1 is protected.

[marius1304]

Thanks for the prompt responses. I think that was the solution