Compile Error: Expected End Sub

**marianmix** · 02-27-2011, 02:51 PM

Hi,
I tried the next code and I have the error: Compile Error: Expected End Sub
Can anyone help me?
Thank you

Please Login or Register  to view this content.

**protonLeah** · 02-27-2011, 02:57 PM

Remove BOTH End Function lines at the end of your SUB

Subs and Functions are not the same. Your code is either one or the other" Sub()...End Sub or Function()....End Function

**watersev** · 02-27-2011, 02:58 PM

hi, marianmix, the code should be:

Please Login or Register  to view this content.

**Marcol** · 02-27-2011, 03:11 PM

You can't use a function as you have posted it.
You need in your module

Please Login or Register  to view this content.

Then call the function like this

Please Login or Register  to view this content.

This code, to me at least, seems a bit over complicated and specialised, and I am nearly certain it is not what you are looking for.

I will ask once again.

What are you trying to do?

**marianmix** · 02-27-2011, 04:02 PM

Thank you for the answers!
The source I got the code is http://www.ozgrid.com/forum/showthre...t=70185&page=1
I want to split a paragraph without breaking the words.
If you have an easy solution i will be glad to hear.
The last code I used was
http://www.excelforum.com/excel-2007...een-lines.html but it breaks the words.

**royUK** · 02-28-2011, 05:31 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.