A Ashish Batham Member Oct 9, 2013 #1 With Cells(2 * reason_count + 35, 2) .Value = "Extract Master" .Font.Bold = True .Font.Size = 10 End With
With Cells(2 * reason_count + 35, 2) .Value = "Extract Master" .Font.Bold = True .Font.Size = 10 End With
Luke M Excel Ninja Staff member Oct 9, 2013 #2 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...
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...
A Ashish Batham Member Oct 9, 2013 #3 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
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
Luke M Excel Ninja Staff member Oct 9, 2013 #4 Correct except for the "If". Cell B37's value will be changed to "Extract Master"