View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sreedhar[_5_] sreedhar[_5_] is offline
external usenet poster
 
Posts: 1
Default 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