Hi

I have 2 defined ranges named 'X' and 'Y' (via Insert>Name>Define). X is A1:F1. Y is B1:F1.

I'm quite new to Names, so aren't familiar with the VBA.

So far I've manged to clear the range via
ThisWorkbook.Names("X").RefersToRange.ClearContents
I'd now like code that copies each of the values in Y into X. However, I need to do this cell-by-cell, rather than in 1 go. This is because there are linkages between rows A and B. Ie, changing cell A1 will result in a change to B2, changes to A2 will change C3, etc.

Hope this is clear, but please let me know if it isn't.

Thanks in advance