Ok! It works! I am passing a variable in a Sub like this:



CallingSub
'This part clears the clipboard
Dim clipboard As MSForms.DataObject
Set clipboard = New MSForms.DataObject
clipboard.SetText ""
clipboard.PutInClipboard

If InStr(StrTxt4, "FSA") > 0 Then
Call FSA(clipboard)

And the called sub looks like this:

Sub FSA(clipboard)
'
' FSA Macro
Dim StrTxt9 As String
StrTxt9 = ActiveDocument.Paragraphs(9).Range.Text
.....more code....
End sub

And my question is this. Best Practices say to use a Function rather than a called sub? Is that right? Ok, but whyis a Function best? I don't get it. For development purposes, I got it going just calling a sub.

Thanks

Its a programming style issue NOT a compulsory part of VBA.

You are free to use sub if you wish.

Slaycock, Ahh.... That makes sense, I couldn't see any good reason why...
By the way, I have got one Sub that calls about 25 other Subs depending on which U.S. Agency is involved. Within each of these 25 Subs there are various conditions tested to see which Email address must be used.
It is a work of art! Calling Subs and passing variables, -I learned a lot. Thanks!
It will be easy to maintain and save some time.

Glad to hear you are making progress.

Do you feel brave enough to share your code with us?