| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make code apply to more than 1 column
I am using this code to insert X in a column with a mouse click. I need this
to apply to other column as well. How do I change this code? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Count 1 Then Exit Sub If Target.Column = 5 Then If Len(Trim(Target.Value)) = 0 Then Target.Value = "X" Else Target.ClearContents End If End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alter code to apply to range (links cells w/ row insertions) | Excel Discussion (Misc queries) | |||
| Problem undstanding how to apply a code | Excel Discussion (Misc queries) | |||
| =COUNTIF & how to make it apply to consecutive cells | Excel Worksheet Functions | |||
| how do I apply changes I make on one sheet to other sheets? | Excel Discussion (Misc queries) | |||
| make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
