- Jan 7, 2019
- Office Version
Greetings, I generally know how to adjust the font size through VBA. However, when I'm trying it now it is changing the whole worksheet. I only want it to affect only the one cell. This cell can moved up or down depending how many entries are in Column A. The following VBA inserts my text perfectly, but i would like in in Times New Roman with font size 12 and in bold. No border.
Sub find_last_plus_3() Lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row Range("A" & Lastrow + 3).Value = "REVIEWED BY:" & " " & Application.UserName End Sub