A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
• | Game - 20 Questions | |
• | Game - Board Game | |
• | Game - Card Game | |
• | Game - Checkers | |
• | Game - Concentration - Memory game | |
• | Game - Create a game | |
• | Generate_deck - udf - that runs commands in spreadsheet to generate ppt slides | |
• | GenerateAllExcelAndDecks - batch - run multiple SQL's and Creates multiple PPT decks | |
• | GenerateExcelFiles from a db - udf | |
• | Get a Random number between 1 and a Million | |
• | Get Address of a Range name | |
• | Get ini file - gsINIFile = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & ".ini" | |
• | GetAllSlideNames | |
• | GetAnchorFromCell - udf - web | |
• | GetCommandLine() - udf | |
• | GetConnection - udf - db | |
• | GetDataFromLink(sLink, sEpic, sDeliv) | |
• | GetDataSource - udf - db | |
• | GetDeliverables | |
• | GetDirName(sFile) | |
• | GetFileBytes - internet | |
• | GetFileCreator - internet - used shell to get the name | |
• | GetFileName(fullpath) - returns the file name without directory | |
• | GetFirstnameFromEmail(s) | |
• | GetHTML | |
• | GetJira | |
• | GetLastModifiedData - gets the last modified data of a web page | |
• | GetLastSlash(s) - File | |
• | GetLatestVersion(sfilename) - get the file with the latest version | |
• | GetMacroCode | |
• | GetNextRow - filtering udf | |
• | GetNextVersion - udf - passed file and returns the next version of the file | |
• | GetParameters - udf - Report engine | |
• | GetRecodset (sSQL, Optional maxRecords) as ADODB.Recordset ' | |
• | GetRegionalTopNames 6 parameters - udf - get a chart of top n based on CE or PE | |
• | GetRester | |
• | GetSignature | |
• | GetStats - udf | |
• | GetSystemVar - udf - db - Retrieves a System Variable from a table | |
• | GettheVersion | |
• | GetUsersEmail | |
• | GetUsersEmailAddress() - udf - internet | |
• | GetVersionForECMTemplates - goes thru a directory and get the last mod and size of each file | |
• | GitHub | |
• | Global variables and variable scope | |
• | Go to First or Last Sheet | |
• | Goal spreadsheet | |
• | Gosub routine_name | |
• | GoTo | |
• | Goto Dialog - Ctrl+G | |
• | Goto Loop | |
• | GoTo next_for | |
• | goto retry_it | |
• | gotolabel: | |
• | GotoSheet - udf - for shortcut creation | |
• | GotoXYZ | |
• | Group/Ungroup/Outline | |
• | GTOD - GetTypeOfDate - e e-system C c-system | |
• | GTODList(sStype, aOffsets) - date Get Type of Date list format "3,6,12,15" a list of prev offsets | |
• | GTODList(type, string of offesets - ex. "0,1,2,3,6,9,12" |