BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
I have a table named "FinalRange90DayBallEdits". The second column of that rate is the date, with each row being a specific calendar day.
When I copy the whole table, in VBA it shows the table selected as
Is there a way to use the same code to specifically copy the "Date" column? SOmething like:
With FinalRange90DayBallEdits
Sum90DayBallEditsTable[#Date].copy <INSERT SPECIFIC DESTINATION HERE>
Anyone know how to do this? I would like to do it via this method because I have to create several specific tables with different data, and I would prefer to select them by their specific name versus referencing a specific cell like range(cells(1, 3).
Thanks!
When I copy the whole table, in VBA it shows the table selected as
VBA Code:
SourceData:="Sum90DayBallEditsTable[#All]"
Is there a way to use the same code to specifically copy the "Date" column? SOmething like:
With FinalRange90DayBallEdits
Sum90DayBallEditsTable[#Date].copy <INSERT SPECIFIC DESTINATION HERE>
Anyone know how to do this? I would like to do it via this method because I have to create several specific tables with different data, and I would prefer to select them by their specific name versus referencing a specific cell like range(cells(1, 3).
Thanks!