Visual Basic_Macro problem

[kkl]

Hey there all you programmers! I'm a novice who's trying to get a macro to work. I got the code for the macro on this forum, previously. It's purpose is to take a cell with a carriage return and split the data into multiple successive cells. In other words, "Name(CR)Address" in one cell will become 2 cells--Cell 1: Name / Cell 2: Address.
Here's the code:

Please Login or Register  to view this content.

My problem is, when I run the macro I'm getting a Compile error: Sub or function not defined.

What am I doing wrong? Or more appropriately, what am I doing?

Thanks all.
--KKL

[shg]

kkl, please read the Forum Rules about thread titles, and then edit your thread title to be descriptive of your problem.

[protonLeah]

The code compiled for me; however, your example states that you have only two values separated by a "CR". The Split function will return a two element array with the count starting at 0 (0,1). Your For..Next loop, though, counts 0,1,2, the '2' being a third and none existent element, so the macro crashes.

[Charlize]

Please Login or Register  to view this content.

Charlize

[kkl]

Thanks, but I'm still getting the same error when I use the new code. Any suggestions?

[Charlize]

My coding works just fine for my. Give a sample workbook with worksheet filled in.

Charlize

[mudraker]

kkl

You have been asked by shg to read the forum rules & change your thread title

Do Not Ignore A Moderates Request

If you do ingnore their requests you may find your threads closed or even worse you may be banned for a period of time

[kkl]

Thanks for the help!

[shg]

kkl, that's two requests you've ignored.

If you wish to continue, please read the forum rules, then start a new thread with a descriptive title.

Thanks.