vba selection change

  1. S

    How can I use VBA to highlight the cell 10 rows under the one the user clicks?

    Hello, I want to highlight (apply a bold format) around the cell that is 10 cells under the one my user just clicked. I know the vba for applying the formatting. Here is what I don't know how to do. I only want this to happen if the user clicks on a certain named range. Pseudo code would be...
  2. M

    Selection Change problem

    I have the following macro in my workbook. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("AV10:AZ10")) Is Nothing Then If IsNumeric(Target) Then Call ShowRanges End If End If If Not Intersect(Target, Range("AU1")) Is Nothing And...

Some videos you may like

This Week's Hot Topics