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
- 3007 reads
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago