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
- 3866 reads

Recent comments
7 years 33 weeks ago
8 years 19 weeks ago
8 years 31 weeks ago
8 years 34 weeks ago
8 years 35 weeks ago
8 years 40 weeks ago
8 years 48 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago