You might mean

Select Case Target.Address
Case "$B$4:$B$5"
For Each cell In target
'do stuff
Next cell
End Select

or maybe

Select Case Target.Address
Case "$B$4", "$B$5"
If ....Then....End If
End Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"D.Parker" wrote in message
...
I have an worksheet with a Case structure for performing centain events is
a
certain cell is selected:

Select Case Target.Address
Case "$B$4"
If ....Then....End If
End Select

So, now I would like to increment to, lets say to cell B5. Is there a way
can set up the following, unfortunately it did not work for me so I
assumed
it was not possibe or better yet I was doing something wrong?:

Instead of Case "$B$4" can I use Case "$i$j" to loop through various
cells?

Thank you.

D. Parker