View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bbxrider[_2_] bbxrider[_2_] is offline
external usenet poster
 
Posts: 10
Default using cell names in vb code

excel 2000
trying to reference changed cells by their cell name in a case statement
with no luck
code is something like this, have tried target.range, target.name, etc
can't seem to find the right combination of target as and select case

Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Range
Case Target.Range("cellName1"), Target.Range("cellName2"), etc
or
Select Case Target.name
Case Target.name("cellName1"), Target.name("cellName2"), etc

i'm thinking there is some way to do this, yes??????