We're 40 percent finished, all seems to be going well...
Just saying hello...I became aware of something while debugging, wanted to share. I find an empty string rather than using the actual wording 'vbNullString' does wonders if I tab twice within the quotes. As previously stated:
gets me what I want most of the time, but " " is now the weapon of choice, I just need to tab twice :
I also complimented the use of vbTab just in case, although I may be way over my head here. I will attempt to not mess with it, unless you see anything. There it is my friends, I am almost there...
Will see all you soon, have a great week-end :-)
Just saying hello...I became aware of something while debugging, wanted to share. I find an empty string rather than using the actual wording 'vbNullString' does wonders if I tab twice within the quotes. As previously stated:
Code:
Dim P As Long
Dim s1 As String
s1 = Text6(0).Text
s1 = Replace(Replace(Replace(s1, vbNewLine & vbNewLine, _
vbNullString), vbNewLine, vbNullString), vbNullString, vbNewLine)
Text6(0).Text = s1
Code:
Dim P As Long Dim s1 As String s1 = Text6(0).Text s1 = Replace(Replace(Replace(s1, vbNewLine & vbNewLine, _ " "), vbNewLine, " "), vbTab, vbNewLine) Text6(0).Text = s1
I also complimented the use of vbTab just in case, although I may be way over my head here. I will attempt to not mess with it, unless you see anything. There it is my friends, I am almost there...
Will see all you soon, have a great week-end :-)
Comment