Hi Bosco6... Can u help me with the coding for selecting the number of cells in column A (Starting from A2) and the number of cells to be selected depends on the value in D9 -Kundan