aragon123321
New Member
- Joined
- Jul 6, 2015
- Messages
- 26
I was just wondering if I could make a message here in my first Sub and then Call it in another Sub. I don't know if this is even possible.
Thank you if you can help in any way.
Here is the code,
Sub Procedure()
Dim Cell, result As String, I As Long
For I = 3 To 17
If Cells(I, 14).Value > 6
Then Call SendMessage
x = " saved message"
Exit Sub
End If
End Sub
--------------------------------------------
sub Sendmessage()
strbody = load message x
Thank you if you can help in any way.
Here is the code,
Sub Procedure()
Dim Cell, result As String, I As Long
For I = 3 To 17
If Cells(I, 14).Value > 6
Then Call SendMessage
x = " saved message"
Exit Sub
End If
End Sub
--------------------------------------------
sub Sendmessage()
strbody = load message x