Thread: 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

Code:

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

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

Code:

Sub Macro()
    Dim Destination As Range
    Dim Source As Range
    
    Set Destination = ThisWorkbook.Names("X").RefersToRange
    Set Source = ThisWorkbook.Names("Y").RefersToRange
    
    Destination.ClearContents
        
    For i = 1 To 10 Step 1
       Destination(1, i) = Source(1, i)
       Next i
End Sub

Paul