Jun 19 2021 10:00 PM
Hi, sorry a beginner here.
I recorded a macro to bold column A, but it bolds the entire page. How can I stop this please?
Thanks
Sub Bold_A()
'
' Bold_A Macro
' Bold Column A
'
'
Columns("A:A").Select
Range("A2").Activate
Selection.Font.Bold = True
End Sub
Jun 19 2021 10:07 PM
SolutionJun 19 2021 10:35 PM
Jun 19 2021 10:49 PM - edited Jun 19 2021 10:49 PM
@Jonwithoutanh When you record a macro, every single key stroke and button you press gets recorded. Scroll the worksheet up or down and it will be recorded as well. Select one cell, then another and then do something with that selection. It's included as three different steps. Once the recording is done, you really need to get back into the code and clean it up. Get rid of the scrolling and buttons you (perhaps) clicked by mistake. And then you can also join the unnecessary ".Select" followed by "Selection." statements into one line of code, as in my example.
Jun 19 2021 11:59 PM
Jun 19 2021 10:07 PM
Solution