Home » Blogs » Nick's blog

XLA routines: EE_TableRemoveHeadings

Nick's picture
Submitted by Nick on 31 January, 2015 - 08:13
EE_TableRemoveHeadings is a function that takes a table of data + headings and returns only the data 
Function EE_TableRemoveHeadings(rngTable As range) As range
'- Takes an EE_table range
'- removes the headings
'- returns a range
'http://excelexperts.com/xla-routines-eeTableRemoveHeadings    for updates on this function

    Set EE_TableRemoveHeadings = Intersect(rngTable, rngTable.Offset(1))
End Function
»