LinkBack URL
About LinkBacks
Hi,
I have found this code on the internet but I don't know how to make it to funtion.
Can anyone tell me what do I have to add in the beggining and in the end to make it work.
Thank you!
Please Login or Register to view this content.
Hi,
I have found this code on the internet but I don't know how to make it to funtion.
Can anyone tell me what do I have to add in the beggining and in the end to make it work.
Thank you!
Please Login or Register to view this content.
Last edited by marianmix; 02-27-2011 at 02:17 PM.
What are you trying to do?
Would "Text to Columns" not be what you are after?
The think is I put the code in the macro and is look like this.
Result: Compile error: Expected End SubPlease Login or Register to view this content.
All codes that I found on the internet and I want to implement give me the same error.
Can be a excel error?
Explain what you are trying to do.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I found the code on the google. The guy who made it said if I use it I could split the paragraph from A1 in other specific cells.
I have the code, I know what it does. The problem is, how I use it?
Please Login or Register to view this content.
Ask the author.
We are asking you what you want to do so that we can offer a solution, not try to interpret what you think is the solution
Ok, let me put it in another way.
I have a code.(doesn't matter what it does).
Where in excel I put codes?
You put the code in a standard module
Thank you for the earlier answer.
I attached a picture. This is a standard module?
Yes, that is a standard module. Just paste the code in, alone. You do not need to add any other code, like you did here:Originally Posted by marianmix
Then in your spreadsheet you can use the function like this:Please Login or Register to view this content.
=SplitText(A1,5,10)
or whatever arguments are appropriate.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
To run the actual code
You would still be better off attaching an example & explaining what you want to do!Please Login or Register to view this content.
hi Marianmix,
In addition to the very sensible requests for you to explain what you want to do...
It looks like you may be biting off more than you can chew. Here is a link for VBA beginners: http://www.mvps.org/dmcritchie/excel/getstarted.htm
which is included in this larger list of helpful links (http://www.excelforum.com/excel-gene...additions.html). I recommend you read through all the ones under "VBA for beginners" & perhaps the Tutorials as well.
Happy learning & Goodluck!
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks