Without your code impossible to say?

Also if it has worked for 2 years what has changed?

New version of Excel, data structure etc. etc.

--

Regards,
Nigel




wrote in message
...
I have had Ron de Bruin's "Merge cells from all or some worksheets
into one Master sheet" macro working successfully on a workbook for a
couple of years now. Suddenly, the macro isn't copying information
from all cells. All rows and columns are being copied/pasted to the
Master Sheet, but it is leaving random cells blank in the master
sheet.

Any ideas???