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
- 6115 reads
Recent comments
6 years 10 weeks ago
6 years 48 weeks ago
7 years 8 weeks ago
7 years 11 weeks ago
7 years 12 weeks ago
7 years 17 weeks ago
7 years 25 weeks ago
7 years 26 weeks ago
7 years 26 weeks ago
7 years 26 weeks ago