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) |