Insert rectangular autoshape using vba based on different cell value

Hi, All

I want to create rectangular bar for my activity based start date and finish date (I don't want to use conditional formatting). What I want is macro will check start date and based on that it will create rectangle to start on that cell and width will be up to end date of any activity.

At present I m not able to attach example file. I will attach as soon as I can.

Regards,

Vishnu

In which cells are the dates stored ?

In which cells is the rectangle to be drawn ?

# A B C D E F G H I J K L M N O
1 Start End 1/1 1/2 1/3 1/4 1/5 1/6 1/7 1/8 1/9 1/10 1/11 1/11 1/12
2 1/5 1/10

Please check above start cell is A2 and End Cell is B2
Now macro will check start date and based on that it will rectangle some where between C2 to O2.
In this example it will be G2 to L2.

Again sorry for inconvenience as I am not able to attaché file now.

Regards,

Vishnu