A drop down box will move the selected range away from the cell you have
selected. there are a few options to try


1) Add a control button on the worksheet. Select the macro you want to
run from the droop down box. Then select the cell you want to use and
push the control button

2) Add an Inputbox to you code to select the cell location during the
execution of the macro.

3) Use a Listbox instead of the dropdown box to select the macro.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146111