convert comma seperated words in a cell to rows (dict data)

[osmanoca]

hello. this is a famous question but i tried a macro code that works in little rows . but i tried my dictionary data it give type missmatch error.

i have two columns for word and meaning. there are 50000 rows. and some meaning cells in column B has many meaning word seperated with comma. i want to use same word but with different meaning rows. i dont know reason of the error in code. perhaps my cells has different character or another thing. or there is a problem in code.


example. two columns A and B

A B
book a, b, c, d and e, a/b

i want macro to convert these row to rows:

A B
book a
book b
book c
book d and e
book a/b


ii dont know other code why gives error. please give me a different macro code to convert data to new rows. please....thanks very much...

 

[Joe4]

Duplicate: type missmatch error in my macro

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.