when i try to make an vba code in excel vba extension at the moment i added
this line to the code of a button:
Range("A1").End(xlDown).Offset(1, 0).Select
it says there is an error but i did exactly what they said on this video
https://www.youtube.com/watch?v=CzP8nO9UVvY
its explained just after 25:12 minutes
I tried the code and it works without errors. Are you sure it's that line it complains about?
This shorter one works to: Range("A1").End(xlDown).Select
The short version doesn't do the same thing as the long version. The short version selects the last value in column A while the long version selects the next empty cell after the last value in column A. (This assumes there are no empty cells in column A as it will stop on the first empty cell)
The code works for me but you have to make sure that you are running it against a sheet that has at least one value in column A. If you run it against a column that has no values in it then it will fail because it will go to the last row in column A and then try to go to 1 row down which causes it to fail.
Good points! If the short version produces a logical error, that may be even worse than a real one. Thanks!
so do i makr it as solved already or can i aks more questions in this one
(next question is: how do i solve this error ? with the short code it does like alraedy said by someone else it goes to the verry last colmn and with the long one it does this error(shown below but when i click debug it shows me the code (Range("A1").End(xlDown).Offset(1, 0).Select) is wrong
You can ask how many questions you want :)
If you want the next empty cell you can try the shorter version that doesn't produce an error. And then move one cell down and see if that works:
Range("A1").End(xlDown).Select
ActiveCell.Offset(1, 0).Select 'move one cell down
Quote