output statement in marco plz
You could use: Debug.Print sStr1
This will show the value of sStr1 in the immediate window.
Hope this helps
Rowan
sreedhar wrote:
hi
my problem is get the result of a loop through output statement for
example
IN THIS LOOP
i want to insert an outputsatement to get result
example:
For Each c In cell
sStr2 = sStr2 & c.Value
sStr1 = sStr1 & c.Offset(-1, 0).Value
HERE I WANT A OUTPUT statement for value in sStr1. to display the value
in the string.
Next
If sStr2 < sStr1 Then
HERE I WANT A OUTPUT statement to display the value in sStr2and
sStr1.
cell.ClearContents
End If
SO, plz help regarding this one
thanks
sree
|