Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2002, Win XP
I have a short WorkSheet_Change macro as below: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("F29:J29", "F93")) Is Nothing Then Exit Sub If Target = "" Then Exit Sub 'Call a macro End Sub I'm getting a Type Mismatch error on: If Target = "" Then Exit Sub and only the 'If Target="" Then' is highlighted I think I've done this before without the error. Maybe I'm thinking of a regular macro. What I want to do is Exit Sub if Target is blank. Where did I go wrong? Thanks for your help. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
"Document not saved" "error in loading DLL" | Excel Discussion (Misc queries) | |||
How to insert a "Target" line into basic bar chart | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) |