Set table column's values equal to a non-table column that has a named range

[sspatriots]

Is it possible to set the table column's values equal to a named range non-table column's values using VBA? I'd like the values in the non-table column to match exactly the values in the table column. I've tried a few things, but the best I could get was to have the first cell in the non-table column to go in the first cell of the table column. Nothing else would pull over into the table column. I use structured references when referring to my table columns and was trying to use a named range for the non-table column. Any help would be greatly appreciated.

 

[Peter_SSs]

Not entirely clear exactly what you are trying to do but see if this helps.

Sub GetValuesFromNamedRange()
  Range("Table1[NamedRngValues]").ClearContents '<- May or may not want this line
  With Range("NamedRange")
    Range("Table1[NamedRngValues]").Resize(.Rows.Count).Value = .Value
  End With
End Sub

 

[sspatriots]

Not entirely clear exactly what you are trying to do but see if this helps.

Sub GetValuesFromNamedRange()
  Range("Table1[NamedRngValues]").ClearContents '<- May or may not want this line
  With Range("NamedRange")
    Range("Table1[NamedRngValues]").Resize(.Rows.Count).Value = .Value
  End With
End Sub

This worked perfectly. I have another issue after that keeps popping up after I run my code through. I'll post that under a different post title. Sometimes I stumble over some of the things that should come easier to me. Thank you.

 

[Peter_SSs]

This worked perfectly.

Thanks for the confirmation.