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 (53 of 1182)

(Clear Filter = *Select*)

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
Selection.Copy - copies the active selection to the clipboard
Selection.Insert Shift:=xlToRight - recorded
Select Case - vba stmt
Sheets("name").select - selects a sheet
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.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)
SelectPartialSheetName - I wouldn't know the whole name of a sheet but knew part of it's name
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.Address - vb property - returns the $A$1 formatted address of the selected cell(s)
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