|
|
#4
03-25-2012, 10:38 PM
|
|||
|
|||
Code:
Option Explicit
Dim Prior As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If [B17] <> "" Then Exit Sub
If Prior Is Nothing Then
Range("A1").Select
Set Prior = Selection
'etc...
|
| Tags |
| named range, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
 load list box from range in excel
|
Joe Patrick | Word VBA | 8 | 06-07-2011 09:31 AM |
|
Named range drop-down
|
jgelpi16 | Excel | 1 | 04-08-2011 03:08 PM |
| Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |
| Through VBA, export range from Excel to Word | duugg | Word VBA | 0 | 08-24-2009 07:50 PM |
Windows XP 
Office 2003
Threaded Mode