How to reference multipal cells in VBA

  • Thread starter Thread starter mikewild2000
  • Start date Start date
M

mikewild2000

I am using
If Target.Address="$C$11" Then

blah blah, etc

But how do i select a group of cells?

I have tried:
if target.address = "$C$11":"$J$11" which just errors,
i have tried various other methods.

Can anybody help with this solution?
Nothing in help
 
Mike,

Try a slightly different approach

If Not Intersect(Target,Range("C11:J11")) Is Nothing Then
....

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thank bob - works a treat.

I was working at the formula for about an hour, and experience tells m
to ask rather than let it spill over for days
 
Back
Top