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 |
| • | Select a cell - Range(...).select | |
| • | Selection. (formula, copy) | |
| • | range(cl(c+1) & fr & ":" & cl(c+1) & r).select | |
| • | Range("A1").select (dup) | |
| • | Select a column - Columns(i).select | |
| • | Cells(i,j).select | |
| • | Selection.Copy - copies the active selection to the clipboard | |
| • | Selection.Insert Shift:=xlToRight - recorded | |
| • | Selection.copy | |
| • | Select Case - vba stmt | |
| • | Sheets("name").select - selects a sheet | |
| • | .Select | |
| • | Range(selection, selection.End(xlDown)).Select - select area - recorded | |
| • | Selection.autofilter = turns off filter | |
| • | Select Case | |
| • | Rows("1:1").select 'a row | |
| • | Selection.Delete Shift:=xlUp ' recorded | |
| • | Columns(1).select - selects a column | |
| • | Selection.cut - Clipboard | |
| • | Selection.NumberFormat = "m/d/yyyy" | |
| • | Selection.Merge | |
| • | Selection.EntireColumn.Hidden = True ' recorded | |
| • | Selection.PasteSpecial ... ' recorded | |
| • | Selection.End(xlUp).select ' recorded | |
| • | selection.PasteSpecial Paste:=xlPasteColumnWidths, ..' recorded | |
| • | ActiveCell.Offset(1,0).select | |
| • | Bs Outlook.Selection | |
| • | set objSelection = objOL.ActiveExplorer.Selection (not sure what this is) | |
| • | SelectPartialSheetName - I wouldn't know the whole name of a sheet but knew part of it's name | |
| • | Selection.CurrentRegion.Select | |
| • | Selection.Left or Top, Height, width, name after chartobject is activated | |
| • | Selection.Autofill destination:=Range("H2:I" & r) | |
| • | Selection.Pastespecial Paste:=xlPasteValues... 'recorded | |
| • | Selection.Replace what:="#N/A", Replacement:="0", LookAt... 'Recorded | |
| • | Selection.WrapText = False ' recorded | |
| • | ActiveWindow.SelectedSheets.Delete - recorded to delete multiple sheets (displayalerts=false) to turn off warning | |
| • | Selection.NumberFormat = (dup) | |
| • | Selection.NumberFormat = "mmm-yy" | |
| • | Selection.NumberFormat = "mmm-yy" (dup) | |
| • | Selection.Numberformat = "#,##0.0,,," | |
| • | Selection.Font.Underline = xlUnderlinestyleSingle | |
| • | Selection.Rows.Count | |
| • | Selection.Address - vb property - returns the $A$1 formatted address of the selected cell(s) | |
| • | PPT.ActivePrenstation.Slides(2).select | |
| • | WildCardSelect(...) - db - udf - adds fields to select query based on wildcards - cool | |
| • | s,Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ::-""??_);_(@_)" 'recorded (g) | |
| • | 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 | |
| • | Selection.Characters.Text = "Add TOC" ' after selecting a button, you can change the text | |
| • | PPT.ActiveWindow.Selection.SlideRange.SlideNumber - get the active slides # | |
| • | Selection Pane | |
| • | Multi-Select |