I cannot say why it works from one location and not another- I would need to see the workbook. If you do not receive an error, the macro must be copying something to a location each time, but it may not be the location you expect. In any event, using Columns.Count made no sense.