Instr runtime error

ook, i must be getting tired. I just realized that i shoudl just check to see if the "-" is in the string before i try and create a new string.

welchs101,

What the code is trying to do is get all text to the left of the hyphen, then remove leading/ending spaces. If there is no dash, there's no text, so when it tries to get text to the left of the dash you get an error. Try this instead:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

EDIT: Looks like you got it before I replied

Hi thanks for the info. I was kinda headed that way.

I did have another question. See enclosed file.

I am trying to parse all the values in col-A of sheet1. For some reason when you run this code (again see enclosed macro) when it reaches a string with a "-" in it ......code just seems to end like it finished.

Please Login or Register  to view this content.

welchs101,

Give this a try instead:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

I closed excel and then restarted it.............re-ran the macro AND IT RAN!!!!!!!!!!!!!

Any ideas why closing down excel and restarting would make it run?

tigeravatar, thanks for the code.......i like it much better than mine. thanks.

any idea why restarting excel caused program to "work"....very strange.

I'm not sure. You declare done = false in the code before the loop, so it should have run without needing to close excel and reopen it.