output statement in marco plz
 

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

--
sreedha
-----------------------------------------------------------------------
sreedhar's Profile: http://www.excelforum.com/member.php...fo&userid=2758
View this thread: http://www.excelforum.com/showthread.php?threadid=47324

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