output statement in marco plz

[sreedhar]

hi


my problem is get the result of a loop through output statement fo
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 valu
in the string.

Next
If sStr2 < sStr1 Then

HERE I WANT A OUTPUT statement to display the value in sStr2an
sStr1.



cell.ClearContents
End If


SO, plz help regarding this one

thanks
sre

 

[Rowan Drummond]

You could use: Debug.Print sStr1
This will show the value of sStr1 in the immediate window.

Hope this helps
Rowan