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 |
| • | Selection. (formula, copy) | |
| • | Selection.Copy - copies the active selection to the clipboard | |
| • | Selection.Insert Shift:=xlToRight - recorded | |
| • | Selection.copy | |
| • | Range(selection, selection.End(xlDown)).Select - select area - recorded | |
| • | Selection.autofilter = turns off filter | |
| • | Selection.Delete Shift:=xlUp ' recorded | |
| • | 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 | |
| • | Bs Outlook.Selection | |
| • | set objSelection = objOL.ActiveExplorer.Selection (not sure what this is) | |
| • | 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 | |
| • | 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) | |
| • | s,Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ::-""??_);_(@_)" 'recorded (g) | |
| • | 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 |