Home » Blogs » Nick's blog

Excel Experts XLA

Nick's picture
Submitted by Nick on 20 September, 2012 - 20:03

Hi all

We are writing an XLA for Excel VBA developers... Please let me know if you can recommend something to be added.

Nick

Type Name
Cleanup EE_ColorSheetTabs
Cleanup EE_End
Cleanup EE_FinalFormatSheet
Cleanup EE_FormatCols
Cleanup EE_HideSheets
Cleanup EE_RearrangeSheets
Cleanup EE_RearrangeSheetsAlphabetic
Cleanup EE_ReplaceErrors
Cleanup EE_Start
Data Manipilation EE_AddTableCalculatedColumn
Data Manipilation EE_ClearColumns
Data Manipilation EE_ClearColumnsData
Data Manipilation EE_ClearRows
Data Manipilation EE_CombineSheets
Data Manipilation EE_CopyAndAddToTheEnd
Data Manipilation EE_DeleteColumns
Data Manipilation EE_ExportRangeToCSV
Data Manipilation EE_ExportSheetToXLS
Data Manipilation EE_ExtractColumnsFromFile
Data Manipilation EE_ExtractRow
Data Manipilation EE_FilterAndCopyToNewSheet
Data Manipilation EE_FilterAndMove
Data Manipilation EE_FilterAndRemove
Data Manipilation EE_InsertColumns
Data Manipilation EE_MergeCSV
Data Manipilation EE_RearrangeColumns
Data Manipilation EE_RemoveDupes
Data Manipilation EE_Table
Data Manipilation EE_TableDefault
Data Manipilation EE_TableFreeHeading
Data Manipilation EE_TableGetColumn
Data Manipilation EE_TableGetColumnData
Data Manipilation EE_TableGetColumnDataAndHeading
Data Manipilation EE_WriteToTextFile
Date EE_AddBusinessDays
Date EE_BusinessDaysInDateRange
Date EE_FirstDayOfMonth
Date EE_FirstDayOfMonth
Date EE_IsBusinessDay
Date EE_IsWeekday
Date EE_IsWeekend
Date EE_LastBusinessDayOfMonth
Date EE_LastDayOfMonth
Date EE_LastFridayOfMonth
Date EE_NextBusinessDay
Date EE_NthWeekdayOfMonth
Date EE_PrevBusinessDay
Date EE_SubtractBusinessDays
Developer EE_SaveIfMe
Email EE_SendReport
Files EE_CheckPaths
Files EE_CopyFile
Files EE_CopyToTempIfDifferent
Files EE_DateFileName
Files EE_DeleteFile
Files EE_FileNameFromFilePath
Files EE_OpenFromTemp
Formatting EE_FormatCols
Pivot EE_ApplyPivotDataFormatting
Pivot EE_CreatePivotFromCSV
Pivot EE_CreatePivotTableFromRange
Pivot EE_PivotArrangeColFields
Pivot EE_PivotArrangeDataFields
Pivot EE_PivotArrangePageFields
Pivot EE_PivotArrangeRowFields
Pivot EE_PivotRemoveFields
Pivot EE_PivotRemoveSubtotals
Pivot EE_PivotTurnOffNonBlank
Pivot EE_RefreshPivots
Range EE_CellFlash
Range EE_Copy
Range EE_CurrentRegionFromCell
Range EE_GetLastPopulatedCell
Range EE_PositionInRange
Range EE_RangeCommon
Range EE_RangeSubtract
Range EE_RangeTrim
Range EE_RangeUnion
Range EE_ReverseSignInRange
Range EE_SortTwoRangesOnCommonIds
Range EE_TableFirstRowRange
Range EE_TableHeadingCol
Range EE_TableRemoveHeadings
Sorting EE_CustomSort
Sorting EE_SortTable
Sorting EE_SortTable2003Comp
Utility EE_AddCalculatedColumn
Utility EE_ArrayCommonElements
Utility EE_CloseOtherWorkbooks
Utility EE_Concatenate
Utility EE_DeleteSheet
Utility EE_DeleteSheets
Utility EE_DeleteTempSheets
Utility EE_Find
Utility EE_GetCellCount
Utility EE_GetColElements
Utility EE_GetComputername
Utility EE_GetTempPath
Utility EE_GetUnique
Utility EE_GetUsername
Utility EE_HeadersCorrect
Utility EE_IsInArray
Utility EE_ListSheetNames
Utility EE_LogError
Utility EE_OpenFileFromCell
Utility EE_ReplaceErrors
Utility EE_ReplaceSheet
Utility EE_SheetExists
Utility EE_SortArray
Zip EE_ZipFile

»