I can read the answer

[montecarlo2012]

Hello, in this thread

VBA to Count the Rows between Occurrences of a Specific Value

I have a worksheet with several thousand rows of data. Column C contains the letters SL at irregular intervals down the column; each cell in the data section of col C is either blank or contains the letters SL. Data starts in row 8. I have two requirements: 1. I need to count the number of rows...

www.mrexcel.com

may be I can find the answer I am looking for but I can read it

 

[MARK858]

Sub MG13May11()
Dim Rng As Range, Dn As Range, c As Long

SetRng = Range("C8:C20000")

For Each Dn In Rng
    c = c + 1
    If Dn.Value = "SL" Then
        Dn.Offset(, 1).Value = c: c = 0
    End If
Next Dn

End Sub

 

[montecarlo2012]

thnak you Mark

 

[YuanChen0824]

Sub MG13May11()
Dim Rng As Range, Dn As Range, c As Long

SetRng = Range("C8:C20000")

For Each Dn In Rng
    c = c + 1
    If Dn.Value = "SL" Then
        Dn.Offset(, 1).Value = c: c = 0
    End If
Next Dn

End Sub

I'm lost, this reply is identical as the answer in the post he referred.
So what's the problem montecarlo2012 had?
I was just stopped by, dmm

 

[MARK858]

He was finding it hard to read because of the old html tags in the original post. I cleaned it up for him that's all.
The code in the original post has been cleaned up by a Moderator now which is why you don't see the html tags that montecarlo2012 saw.

 

[montecarlo2012]

thank you Mark, I see the japaneese is new he still don't know whats going on here

 

[MARK858]

@montecarlo2012 the poster isn't Japanese and it was a legitimate question as the tags have been tidied up now in the original post and so the issue wasn't visible to the poster

 

[YuanChen0824]

@montecarlo2012
I'm... not a Japanese. I'm from Taiwan. You're good tho
It's nice that your problem had been answered.

 

[Joe4]

thank you Mark, I see the japaneese is new he still don't know whats going on here

There is no need for that comment. Please refrain from making those type of comments in the future, especially when you post is confusing because it is filled with typos (for example, it should say "I CANNOT read the answer", not "I can read the answer").

 

[montecarlo2012]

Dear forum members,
I would like to apologize for my recent behavior on this forum. I realize that my comments and questions may have come across as confrontational and inappropriate, and I regret any offense or disruption that I may have caused.
I understand that forums like this are meant to be a space for respectful discussion and exchange of ideas, and I should have been more mindful of this in my interactions with others. Instead of engaging in constructive dialogue, I allowed my frustration to get the best of me, and for that, I am sorry.
I also want to acknowledge that I may have contributed to the escalation of conflict by responding defensively or aggressively to others' reactions to my comments. This was not helpful or productive, and I recognize that I should have approached things differently.
Moving forward, I will make a conscious effort to communicate more respectfully and constructively on this forum. I will strive to listen to others' perspectives and engage in dialogue that is focused on understanding and learning, rather than winning arguments or proving a point.
Once again, I apologize for any harm that I may have caused, and I hope that we can all work towards creating a more positive and productive environment for discussion on this forum.
Sincerely,
Montecarlo2012