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 |
| • | a Excel/VBA for yourself vs. users of your sheets (18) | |
| • | vlookup to external file - '[file name.xlsm]sheetname'!$C:$F | |
| • | Activesheet.paste | |
| • | Sheets("name").select - selects a sheet | |
| • | CreateSheet "name" - adds a new sheet and deletes current one??? udf | |
| • | Workbooks(thisworkbook.name).sheets("xxxx").Range("DER_cc") ' get the range name in another workbook | |
| • | Display_the_columns - takes a spreadsheet and hides columns based on a range name - udf | |
| • | ThisWorkbook.Sheets(....).Range(....) ' use when a different sheet is active | |
| • | GettheVersion | |
| • | GotoSheet - udf - for shortcut creation | |
| • | CreateHTMLTableForEmail (html, css,) - coverts spreadsheet visible data to HTML format | |
| • | ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded | |
| • | ActiveSheet.Index - gets the sheets number (not sure why you'd use this | |
| • | ShowSheet - udf - wraps the code to prevent errors | |
| • | After opening an external spreadsheet verify that it's okay - coding | |
| • | SelectPartialSheetName - I wouldn't know the whole name of a sheet but knew part of it's name | |
| • | Sheets(Array("sheet1","sheet2").copy | |
| • | ActiveSheet.name | |
| • | Generate_deck - udf - that runs commands in spreadsheet to generate ppt slides | |
| • | ActiveSheet.ChartObjects(sFromAddr).Activate | |
| • | Activesheet.ChartObjects(sToAddr).Delete | |
| • | Delete a Sheet - turn off displayalerts before delete (sh.delete) | |
| • | Create a Sheet with a number of columns to run queries and process Excel output | |
| • | Setting Sheet | |
| • | LogAction - udf to write 3 fields to a sheet | |
| • | Sheets.count | |
| • | Sheets(2).visible = True | |
| • | When deleting work backwards: for x = sheets.count to 1 step -1 (loop) | |
| • | LoadArray(workbookname, Sheetname, header) 🔝 | |
| • | PPT test code to update embedded spreadsheet in ppt | |
| • | Protect/Unprotect a sheet | |
| • | ActiveSheet.Unprotect | |
| • | ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded | |
| • | Protecting a Sheet | |
| • | Activesheet.PivotTables("PivotTable11").PivotFields("CtryOfDom").PivotItems ' recorded | |
| • | ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ... ' recorded | |
| • | ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh ' recorded | |
| • | ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").ClearAllFields 'recorded | |
| • | ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").CurrentPage = sValue | |
| • | ActiveSheet.Copy After:=Workbooks(sMainWBK).Sheets(Sheets.count) | |
| • | ActiveWindow.SelectedSheets.Delete - recorded to delete multiple sheets (displayalerts=false) to turn off warning | |
| • | Workbooks(sWBK).Sheets("CPR_LIst").Range("portfolio") | |
| • | Sheet names have size and character limitations | |
| • | sheets vs. worksheets collection? | |
| • | ActiveSheet.PivotTables("pt1").PivotFields("Acct_nbr").Autosort xldescending, sort ' recorded | |
| • | ActiveSheet.PivotTables("pt1").PivotFields("coper_id").PivotFilters.Add Type:=xlTopCount, DataFiled:=... ' recorded | |
| • | ActiveSheet.PivotTables("pt1").ColumnGrand = True ' recorded | |
| • | Activesheet.Names(sName).Delete ' deletes a named range | |
| • | Insert_to_dataissues_click | |
| • | LoadSQLtoSheet | |
| • | ProcessSQL(sSQL, sSheet, optional sProcess | |
| • | As Worksheet | |
| • | WorksheetFunction.Min( ) I use application.evaluate | |
| • | WebQuery - internet - udf - run a url and loads the output to a worksheet - recorded | |
| • | ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers | |
| • | FormatMultipleSheets udf | |
| • | WorksheetFunction.Min | |
| • | ActiveSheet.Buttons.Add(top,left,width,height).select 'not sure of the params | |
| • | Activesheet.Shapes.Range(Array("Button 1")).Select | |
| • | Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select | |
| • | Making Spreadsheets more Professional Looking | |
| • | Sheets Collection | |
| • | Sheets aka WorkSheets | |
| • | RetrieveDataToSheet - udf - db | |
| • | SpreadSheetRoutines.bas | |
| • | Large Spreasheets | |
| • | Go to First or Last Sheet | |
| • | Forecast Sheet | |
| • | Create sheets from a list | |
| • | Testing you Spreadsheet or Macro | |
| • | Running a batch and opening a new spreadsheet Issue - IgnoreRemotedde | |
| • | sheet names | |
| • | Health spreadsheet | |
| • | Networking spreadsheet | |
| • | Goal spreadsheet | |
| • | DeleteSheet | |
| • | DeleteSheets | |
| • | SendEmailFromList - Goes thru a spreadsheet and Sends emails | |
| • | SheetExists - udf | |
| • | 11/12/14 Compare Sheets |