Re: please help

What sort of syntax error? I just copy-pasted the code from Google
(which I use for my newsgroup interface) to a new workbook and it
worked right away. Sometimes, depending on your browser and window
size, etc., line breaks will be introduced in the copy-paste step that
weren't in the original code. If you paste code into a code window and
see syntax errors on 2 consecutive lines, try combining them into 1
line. I would be surprised if any version compatibility issues were
involved.

HTH

-John Coleman

On Jan 29, 1:01 am, sunyp...@xxxxxxxxx wrote:
Although i have used excel quite a bit, i have very limitted knowledge
about the functions. Similarly, i used macro by automaticaly recording
way back when but not at all vba programing. i would like to
manipulate internet-downloaded data where the split of strings into
separate cells is needed. i am having fun with code given by Mr.
Coleman. I am having a compile syntex error. Maybe my excel version is
not compatlbe.
Appreciate all the help i am getting.

On Jan 28, 6:44 pm, "Joerg" <n...@xxxxxxxxxxxxx> wrote:



Why would you need VBA? You could use standard Excel funcionality:
Go to Data = > Text to Columns and define comma as your delimiter.

Joerg

<sunyp...@xxxxxxxxx> wrote in messagenews:1169999334.820016.104040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Would anyone please help me write a VBA progam to do the following:
A cell (e.g. Cell(A1)) contains a string; alphet, 12.3, 23.4, 56.7
Break the string and put each of them in separate cells (e.g.
alphbet in Cell(B2), 12.3 in Cell(C2),
23.4 in Cell(D2), and 56.7 in Cell(E2)).
Thank you,- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

.

Relevant Pages

  • Re: kid wants to know more about color on the screen
    ... He and I have no programming ... > does a run script there will be a syntax error as Python wont recognize this ... it is possible to print colored text in Python. ... These are strings starting with the control ...
    (comp.lang.python)
  • SNMP community string starting w/special a prob on Sol 8?
    ... Our standard community strings start with a special character. ... syntax error in at line 20: the token < is not valid ... Trying to 'quote' or "quote" the strings yielded: ...
    (SunManagers)
  • Re: Newbie question on INSERT command
    ... The error I get back indicates a syntax error. ... Did you really spell Address1 and Addres2 so ... The zero length strings may or may not be a problem, ...
    (comp.databases.ms-access)
  • Re: Compile error about MACRO
    ... In the MERGE macro, a is replaced by the string "hello", not the token ... You only use quotes in macro arguments when you want strings. ... which is definately a syntax error. ... operator works on tokens not on strings. ...
    (microsoft.public.vc.language)