Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This code keeps throwing errors. The If statement is in yellow when
the VB window comes up. I have tried putting other code in thre and it seems to work fine. I do nto knwo if there is an issue due to adding columns. Please help. Thanks, Jay Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Target.Address = "$I$2" And Target.Value = "Inner Box Base" Then Columns("K:L").Insert Shift:=xlToRight Columns("I:J").Copy Destination:=Columns("K:L") Range("K2") = "Inner Box Lid" Else Exit Sub End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
What is worng with my formula? | Excel Discussion (Misc queries) | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |