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

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (37 of 1075)

(Clear Filter = *Cell*)

Assign a value to a cell - Range("xxx") = "a value"
Range vs. Cells
Select a cell - Range(...).select
Activecell.formula
Activecell.formulaR1C1 = .... - code from macro recorder
Cells(i,j).select
Cells
Cells.autofilter field=lCol, Criteria1:="=*IBM*", Operate:=xlOr, Criteria2:="IBOR*"
ActiveCell.Address
ActiveCell.Offset(1,0).Address
ActiveCell.Offset(1,0).select
MergeCells
Cells.Rows.Count
Load cell value to a vba variable
Range("A1:" & Cells(r,c).Address).Copy
if .Cells(i,j) ' referencing the with stmt
Cells(i,j).Text
Activecell.FormulatR1C1
Cells.Clear - Clear all cells
Activecell.Row
Activecell.Column
Selection.Address - vb property - returns the $A$1 formatted address of the selected cell(s)
AC - udf sc - Activecell
AR - sc for Activecell.row
Down1 - sub to move activecell down 1 row sc
Right1 - udf - move activecell 1 to the right
Activecell.formulaR1C1 =
Activecell.formulaR1C1 = "=If(RC[-32]=0,0,RC[-10]/RC[-32]
SetAutoFitMergedCell udf Report Engine
Activecell.mergecells
activecell.MergeArea
GetAnchorFromCell - udf - web
Rows, Columns and Cells
Drop-down list in a Cell - Data Validation
pptshp.Table.Cell(i, 1).Shape.TextFrame.TextRange.Text - gets the text from a pptshp cell
Setting a Hyperlink on a cell in a ppt table
Cells, Rows, Columns and Ranges
Top
   
Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit