I need the solution applied to many workbooks and multiple records on each worksheet. I have to be able to select the range and apply the code over the selected range. Thanks