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 |
• | Thisworkbook (xl reserved word) | |
• | Workbooks(thisworkbook.name).sheets("xxxx").Range("DER_cc") ' get the range name in another workbook | |
• | ThisWorkbook.Sheets(....).Range(....) ' use when a different sheet is active | |
• | set objSelection = objOL.ActiveExplorer.Selection (not sure what this is) | |
• | ActiveSheet.Index - gets the sheets number (not sure why you'd use this | |
• | ThisWorkbook.Activate | |
• | Thisworkbook.path | |
• | Run "Thisworkbook.WorkBook_Open" | |
• | Get ini file - gsINIFile = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & ".ini" | |
• | ThisWorkbook | |
• | This Workbook contains links to one or more external sources [update] [don't update] | |
• | FixEmail - Take an email address with < > and remove this |