XLA Routines: EE_TableDefault

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
»
- Nick's blog
- Login or register to post comments
- 6023 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago