• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help to understand this With statement

With that particular cell, make the value "Extract master", the font is bold, and the font size is 10.
I'm not sure what your question was exactly...
 
Pleased advice, if my understanding if correct

Considering reason_count=1
With Cells(2 * reason_count + 35, 2) 'with cell (2*1)+35,2----(B37)?
.Value = "Extract Master" 'if value of B37 is "Extract Master"
.Font.Bold = True 'font to be bold
.Font.Size = 10 ' font size to be 10
End With
 
Correct except for the "If". Cell B37's value will be changed to "Extract Master"
 
Back
Top