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