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
- 3095 reads
Recent comments
5 years 51 weeks ago
6 years 37 weeks ago
6 years 49 weeks ago
7 years 1 day ago
7 years 1 week ago
7 years 6 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago