-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
selection.font
-
D
How to merge 2 codes that do the same thing for 2 separate cells into 1 code?
Hi, Please could someone help me? I have this following 2 codes that works fine but I was wondering how it can be made into 1 code? Cells(Rows.Count, "A").End(xlUp).Select Selection.ClearComments With Selection.Interior .Pattern = xlNone .TintAndShade = 0...- danbates
- Thread
- .patterntintandshade .tintandshade end selection.font xlnone
- Replies: 4
- Forum: Excel Questions
-
U
How to avoid writing 50 or more Subs
I plan to add 50 CheckBoxes to a ws in my project. Other than creating 50 Subs to handle these events, can I get suggestions on how to: Sub CheckBox3_Click() Application.ScreenUpdating = False If CheckBox3.Value = True Then Range("B3:V3").Select With Selection.Font .ThemeColor =...- underpressure
- Thread
- end false rangeb3v3.select selection.font true
- Replies: 9
- Forum: Excel Questions
-
J
VBA code error
Writing this code: Receives error: Compile error - Method or data member not found. Sub Sizing() Range("a1:J125").Select With Selection.Font .Name = "Arial" .size = 8 End With End Sub- jakobt
- Thread
- code end error selection.font sizing
- Replies: 5
- Forum: Excel Questions
-
K
Why doesn't this worksheet level macro work?
Why doesn't the VBA below work? If range Z1 = "NO", nothing happens. Thanks! Private Sub Worksheet_Change(ByVal Target As Range) If Range("Z1") = "NO" Then 'strikethrough Range("A1:Q14").Select With Selection.Font .Strikethrough = True End With...- kwp004
- Thread
- .strikethrough end false selection.font true
- Replies: 4
- Forum: Excel Questions
