Create an Excel Macro that Highlights Rows
from Technology for Teachers and Students Hosted by ytr
Learn how to create a VBA Excel Macro that will highlight every other row of whatever area of your spreadsheet that is selected. See below for the VBA code for this macro. This video is one in a series that\'s meant to help VBA macro beginners become more comfortable with creating macros. My entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here\'s the practice file that goes with this video: http://bit.ly/excelhighlightmacro #exceltutorial #excel #excelmacros Books to help you make Excel VBA Macros: Excel VBA Programming for Dummies: https://amzn.to/3piWIZ5 Excel Power Programming with VBA: https://amzn.to/3ph323p VBA Automation for Excel: https://amzn.to/36cGPff Here\'s the VBA code for this macro: Sub HighlightEveryOtherRow() Dim Myrange As Range Dim Myrow As Range Set Myrange = Selection For Each Myrow In Myrange.Rows If Myrow.Row Mod 2 = 1 Then Myrow.Interior.Color = vbCyan End If Next Myrow End Sub
Embed this episode
No transcript yet.