Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
home_server:mswindows_notes [2025-03-18 Tue wk12 16:55] – [MS Excel Highlight Row or Column] baumkphome_server:mswindows_notes [2025-03-18 Tue wk12 17:10] (current) – [MS Excel Highlight Row or Column] baumkp
Line 227: Line 227:
  
 Use a VB macro.  Main down side to this is that it slows down the MSExcel performance Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
-<code>Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)+++++VB Code 1| 
 +<code> 
 +'from https://www.exceldemy.com/learn-excel/highlight/row/ 
 +Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
 +  If Target.Cells.Count > 1 Then Exit Sub 
 +  Application.ScreenUpdating = False  
 + 
 +  'Clear the color of all cells 
 +  Cells.Interior.ColorIndex = 0 
 +  With Target 
 +    'Highlight row and column of the selected cell 
 +    .EntireRow.Interior.ColorIndex = 38  'or use RGB(200,200,200) to pick a colour 
 +    .EntireColumn.Interior.ColorIndex = 24 
 +  End With 
 +  
 +  Application.ScreenUpdating = True 
 +End Sub</code> 
 +++++ 
 + 
 +++++VB Code 2| 
 +<code>'from https://www.howtoexcel.org/highlight-current-row-column/ 
 +Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
 Static xRow Static xRow
 Static xColumn Static xColumn
Line 251: Line 272:
 End With End With
 End Sub</code> End Sub</code>
 +++++
  
 =====Text to Column===== =====Text to Column=====