XLA routines: EE_TableGetColumnData
EE_TableGetColumnData takes a heading and returns only the data
Function EE_TableGetColumnData(Heading As String) As range ' returns the data from a header 'http://excelexperts.com/xla-routines-eeTableGetColumnData for updates on this function Set EE_TableGetColumnData = Columns(EE_TableHeadingCol(Heading, ActiveSheet.UsedRange)) Set EE_TableGetColumnData = Intersect(EE_TableGetColumnData, ActiveSheet.UsedRange) Set EE_TableGetColumnData = EE_RangeChange(EE_TableGetColumnData, 1, 0, 0, 0) End Function
»
- Nick's blog
- Login or register to post comments
- 2973 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago