Hi Dgagnon,

Thnks for the help but I am not able to manage the Placement as I actually I require it almost at the same level as the selected Column B next to it...somewhere Column C..
But it does move which is important..

Hi Dave,

Nice Avatar..
Actually your code is absolutely wonderful, I mean I had hardly explained well this time and you produced a real gem..

I am inspired with this and was thinking of having two buttons enclosed in a small user form, is that possible too..

Application :
I am entering the Term Deposit information and sometimes some FD's are continued so I just would go in the selected cell and then I would hvae this Button Visible ( User Form ) Visible which has two buttons one Command Button would be to continue with the same Tenure and the other Command Button would be to continue with a new tenure...

WIll that be possible, unfortunately my file is not ready but is it ok this way as technically the the thread is SOLVED but I just realized that having two buttons would serve a better purpose...the user form containing these 3 Command Button needs to be moving..

Warm Regards
e4excel