Hi Raju

A)
Never use Merge cells, always trouble(for example if you want to filter)

B)
You can use this
If Not Application.Intersect(Range("A1:A20,C1:C20"), Target) Is Nothing Then

C)
This is not allowed as far as I know



--
Regards Ron de Bruin
http://www.rondebruin.nl


"R K TOLANI" wrote in message ...
Hi Ron,
Thanx for the great routine for calendar popup in an excell cell.
I have three issues:
a) The routine doesnt work with merged cell, i.e. it doesnt show the
calendar when needed in a merged cell nor does it hide the calendar when the
cursor moves to a merged cell
b) How do I show calendar popup at different places in the worksheet?
c) How do I distribute calendar.ocx with my template?

Please help.

- Raju Tolani



"Ron de Bruin" wrote:

Hi dyowell

Maybe this will help
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dyowell" wrote in message ...
I have a worksheet that has a date column. I would like
to be able to click in the column and bring up a calendar
view to choose the date. I have no idea how to do this,
but thought that maybe someone could help lead me in the
right direction. Thanks in advance for the help.