Macro doesn't delete space at the end of every number in column

Hello. I have a file I need to make changes to before importing it to another workbook. I recorded a macro that makes the changes for me. In the code I have two questions. Column A:A has a series of numbers, but they contain a SPACE at the end of the number. I need to delete that space at the end of every number in the whole column. Why does it not delete the space at the end of each number in column A:A? It only deletes the one in the first cell A2. The macro must rename the sheet in that file TPCC always, but the name of the sheet will change from one month to the other for example this month its TreimentosPorCentroDeCusto but next month it could be TreimentosPorCentroDeCusto (4). How can it make the change no matter what the name might be? I have posted part of the code below for reference.

Please Login or Register  to view this content.

Does this help?

Please Login or Register  to view this content.

OK great but Actually I began to program the macro and got stuck when I came across that part so I recorded it. Sorry I'm still a rookie... Here is the entire code.

Please Login or Register  to view this content.

@JohnDavis that worked great deleting the space at the end... Do you have any advise as far as the Renaming of the sheet? Its nice to see someone from Jersey here on the board I'm originally from North Arlington... Thanks

@John
Would it be better to use

Please Login or Register  to view this content.

instead of this

Please Login or Register  to view this content.

on the offset chance that it has numbers without a space?
I realize that Will03 said that all the numbers have a space at the end but one never knows!

North Arlington eh. Not far:

Not the best solution, but maybe:

Please Login or Register  to view this content.

Originally Posted by jolivanes

@John
Would it be better to use

Please Login or Register  to view this content.

instead of this

Please Login or Register  to view this content.

on the offset chance that it has numbers without a space?
I realize that Will03 said that all the numbers have a space at the end but one never knows!

I agree with you, but Will03's first code should have worked in my opinion. The only thing I could think of is that the spaces he was seeing were actual not spaces but other characters. So I offered the Len solution.

@John
OK, your thinking is ahead of my thinking.
Thanks John

Thanks for the Help guys all done with the first part of the Macro and will begin part two... Hope if something comes up you may assist me as well. Here is the whole code working to perfection.

Please Login or Register  to view this content.