Forum Discussion
Antje_CO
Dec 30, 2019Copper Contributor
VBA error: 1004 method 'range' for object global failed
Hello, I guess it´s a just a little mistake in the code, but I can´t find it. Maybe someone can help me. I have to sort may different Exports (different meaning the first and last written cell is va...
Riny_van_Eekelen
Jan 01, 2020Platinum Contributor
If you change the piece with "Sort Key1" to:
.Sort Key1:=Cells(rng.Row, rng.Column)
.... it should work.