Hey guys,
I have an important question, because when I type in something like
last = ActiveSheet.Cells(Rows.Count, 9).End(x1Up).Row to select everything until the last cell, then I get the runtime error 1004, even though I did everything exactly the same like the Yotuuber did in his video that I was watching.
But also commands like
.Borders(xlInsideHorizontal).LineStyle = x1Dash
.Borders(xlInsideVertical).LineStyle = x1Continuous
.Borders(xlEdgeBottom).LineStyle = x1Double
just don´t work. Nothing happens.
Or even the follwing command also brings me a runtime error 1004.
With Range("E1:F3")
.Merge
.Value = "Neuer Text"
.HorizontalAlignment = x1Center
.VerticalAlignment = x1Center
I have the suspicion that i has to do with those x1(..) things, does someone maybe have the same problem or knows a solution? Maybe a setting which disables those commands?
You would help me so much!
Toby