Run-time error '1004': Application-defined or object-defined error vba Excel

Question

I am doing a vba macro to get data from sheets of an excel document, way that I do it:

Worksheets("EN").Range("5A").value

But for some reason Run Time Error 1004 is outputted. If I try to loop Worksheets elements and see the Name or Index value, all sheets are properly get, but when I try to get .Range("5A").value 1004 Error is outputted. For some reason, value command is with minus "v", if I try to put Value key, IDE automatically change the key "Value" to "value".

what can explain this behavior?

Thank you.

Worksheets("EN").Range("A5").value

braX
– braX

2017-10-31 14:33:20 +00:00
Commented Oct 31, 2017 at 14:33 — braX
– braX, Commented Oct 31, 2017 at 14:33

Harassed Dad · Accepted Answer · 2017-10-31 14:33:52Z

1

It's Range("a5") not range("5a") Column letter then row number

answered Oct 31, 2017 at 14:33

Harassed Dad

4,7141 gold badge12 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run-time error '1004': Application-defined or object-defined error vba Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related