Hi I try to make an selection in a macro, but it seems to make an selection to the end of the column. For example... the cells are now filled till B144 but after using Range(Selection, Selection.End(xlDown)).Select it goes to B65536. Same happens when I do this manually with Ctrl End Down keys.

How can I fix this?

Is there an other way to make this selection?