Thanks again.

That does work but only if I copy one cell at a time and I have 25 rows that are 36 columns wide (900 cells) and will grow each month by a column! Also it strangely will not copy down a column, even one cell at a time.

Is there any way to copy the first cell across a row?

Thanks for your patience and help.