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
- 3135 reads
Recent comments
6 years 6 weeks ago
6 years 44 weeks ago
7 years 4 weeks ago
7 years 7 weeks ago
7 years 8 weeks ago
7 years 13 weeks ago
7 years 21 weeks ago
7 years 22 weeks ago
7 years 22 weeks ago
7 years 22 weeks ago