Just drop that code into a standard module. Skip back to Excel and select the cell you want to modify. Run the macro and input the description you want when prompted. If you select more than one cell, all the cells will have the same description applied.UniMord said:...how do I apply this function to the column in question?