Re: I was given this macro from this group

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steved (anonymous_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Thu, 3 Feb 2005 22:15:27 -0800

Hello from Steved

I am very new at this and have no idea about the
terminology and subsequently i've now have no idea
what to do with your kind answer. Please understand
the reason I came to this sight is to get an answerto my
issue, and the end result would be that it works. You are
asking me to understand code which is new to me so please
if you would bare with me please just show me how I can
get your macro to function. In other words a) and b)I
cannot comprehend.

Thankyou.

>-----Original Message-----
>By now you should have learned enough about coding to
actually read and
>think about these code snippets. You can't just paste
them into a module and
>pray.
>
>a) Insert, in place of Range.Text, whatever string
you're working with.
>
>b) Declare all the variables.
>
>
>
>
>
>"Steved" <anonymous@discussions.microsoft.com> wrote in
message
>news:03c101c50a79$d2c98570$a501280a@phx.gbl...
>> Hello from Steved
>>
>> The below macro Keeps highlighting the belowand will
not
>> work please help.
>>
>> pWords = Split(Range.Text, " ")
>>
>>
>> Sub Testing()
>> Dim pWords() As String
>> pWords = Split(Range.Text, " ")
>> For i = 0 To UBound(pWords)
>> If pWords(i) Like "[a-zA-Z]{1,}" Then
>> pStartWord = i
>> Exit For
>> End If
>> Next
>>
>> Output = pWords(pStartWord)
>> For i = pStartWord + 1 To UBound(pWords)
>> Output = Output & " " & pWords(i)
>> Next
>> End Sub
>
>
>.
>

Relevant Pages

  • Re: I was given this macro from this group
    ... By now you should have learned enough about coding to actually read and ... think about these code snippets. ... Insert, in place of Range.Text, whatever string you're working with. ... > Sub Testing() ...
    (microsoft.public.word.vba.general)
  • Compile-time text/string manipulation
    ... A "compile-time language" is one that processes ... Compile time languages for assemblers ... This group includes macro ... requires access to various string and text manipulation ...
    (alt.lang.asm)
  • RE: Search email for text string to use in filename - save email t
    ... The code for my macro is below. ... .MatchWholeWord = False ... Dim sNewFileName As String ... > 0 Then Exit Function ...
    (microsoft.public.outlook.program_vba)
  • Re: Iding tabs that contain #REF!s
    ... The code I sent you just a little while ago does not seem to work correctly; try this macro instead... ... Sub Findrefs() ... Dim WS As Worksheet, Res As String, TempArrayAs String ... I just had those sheets hidden, but your suggested fix now looks at only the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Document Property to display more than 1 line
    ... then use the following macro to identify the character ... Dim strNums As String ...
    (microsoft.public.word.newusers)