Home » Blogs » Nick's blog

XLA Routines: EE_TableDefault

Nick's picture
Submitted by Nick on 9 February, 2016 - 15:43
Creates a range object that represents a table of data - used to pass to other subs that require data 
Function EE_TableDefault(Optional rngTable As Range) As Range
'http://excelexperts.com/xla-routines-eeEE_TableDefault    for updates on this function
' returns the currentregion around the first cell - a good guess for a table of data's range
    
    Set EE_TableDefault = rngTable
    If rngTable Is Nothing Then
        Set EE_TableDefault = ActiveSheet.Cells(1).CurrentRegion
    End If
 
End Function
»