By using you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σ


Standard VBA/Excel (34 of 1182)

(Clear Filter = *Selection*)

Selection. (formula, copy)
Selection.Copy - copies the active selection to the clipboard
Selection.Insert Shift:=xlToRight - recorded
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.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.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.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