sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 585
- Office Version
- 365
- Platform
- Windows
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.