From workbook, right click on the sheet tab View Code and paste the code
which Shane provided..and then try.

Remove the code from

If this post helps click Yes
---------------
Jacob Skaria


"Seaq" wrote:

Thanks Shane.

As a VBA newbie so I pasted in the code and replaced the [c1] with my drop
down list cell, an error message replies " object required" for line Set
isect = Application.Intersect(Target, G1)? can you help?