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 |
| • | 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 | |
| • | Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows) |