remove whitespace or tabs

HI ALL.

I'm looping through an array and trying to remove any leading or ending whitespace but I can't seem to figure out why it's not working as I get extra values which I believe are hidden TABS. Here is my code below to try and clean the array value . What am I doing wrong.

Please Login or Register  to view this content.

"")

Does this work?

Please Login or Register  to view this content.

Just tried and it did not work. AHHHHHHHHH!!

Tracy

How is it not working?

No change?

Do you have a line like

Please Login or Register  to view this content.

after the line?

Otherwise I need to see actual string.

this is what I have while looping. it's a mess.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Should do.

still dont work. What I did was in a text file i simply enter numbers. I would type 22 hit enter then hit tab enter 23 tab tab enter 24. I copied this into my userform and submitted it into an array and get 6 values 3 of them blank because of the tab.


22

23


24

Then try

Please Login or Register  to view this content.

Add this function somewhere outside above procedure.

Please Login or Register  to view this content.

I'll give it a try now and reply back

still not working

Every suggestion I gave is working here, so no idea why it doesn't work at your side.