Using Names

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

Please Login or Register  to view this content.

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

Thanks very much for the reply. Just for reference, I think I've cracked it:-

Please Login or Register  to view this content.

Paul