Excel Macro code to Highlight the Active Row and Column

Share on facebook
Share on linkedin
Share on email
Share on whatsapp

How to Highlight the Active Row and Column in excel sheet through VBA Macro Code

For using this VBA macro code in excel to Highlight the Active Row and Column you will have copy below Macro code in Excel Visual Basic Editor
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strRange As String
strRange = Target.Cells.Address & "," & _
Target.Cells.EntireColumn.Address & "," & _
End Sub

This very useful macro code whenever you want to analyze a data table. You can Highlight the Active Row and Column. Here are the quick steps to apply this code.

  1. Open VBE (ALT + F11).
  2. Go to Project Explorer (Ctrl + R, If hidden).
  3. Select your workbook & double click on the name of a particular worksheet in which you want to activate the macro.
  4. Paste the code into it and select the “BeforeDoubleClick” from event drop down menu.
  5. Close VBE and you are done.

Remember that, by applying this macro you will not able to edit the cell by double click.

What is a Macro Code?

In MS Excel, macro code is a programming code which is written in VBA (Visual Basic for Applications) language.

The idea is to use macro code for automating various activities which you perform manually in Excel, otherwise.

For example, you can use a code to print only a particular range of cells just with a single click instead of selecting the range -> File Tab -> Print -> Print Select -> OK Button.

How to use a Macro Code in Excel


  • On the left side in “Project Window”, right click on the name of your workbook and insert a new module.


  • Just paste your code into the module and close it.


  • Now, go to your developer tab and click on the macro button.


  • It will show you a window with a list of the macros you have in your file from where you can run a macro from that list.





Training Attendance Sheet

Whether you’re organizing any training program for an athletic event. A technology course, or a chess tournament, a good attendance …

Download Now

Weekly Attendance Sheet

Our “Weekly Attendance Sheet” is simple, compact, and useful an all-purpose attendance tracker. This attendance tracker includes one worksheet with …

Download Now

Student Attendance Sheet

These student attendance sheet records is create to help teachers keep track of attendance of their students. There are two …

Download Now

Shift Planner with Tracker

Shift Planner with Tracker for Excel is a powerful spreadsheet that help any Human Resources or operational managers creating their …

Download Now

Employee Attendance Tracker

The free employee attendance tracker template is one of my popular excel templates. I have create a more general employee …

Download Now

Islamic Calendar

The Islamic calendar (it is known also as Muslim calendar or Hijri calendar) is a lunar calendar based on 12 …

Download Now