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 |
| • | FindDataCol("fieldname",row_nbr) udf | |
| • | Filtering and visible rows | |
| • | GetNextRow - filtering udf | |
| • | Rows(i).hidden | |
| • | Rows collection | |
| • | Hide columns or rows on a report | |
| • | Findlastrow - udf - finds the last row in a column | |
| • | mixing up row and column error | |
| • | Rows - basic | |
| • | FindLastCol(1) - find the last column passed a row udf | |
| • | Rows("1:1").select 'a row | |
| • | RemoveCanceled - Removes rows with a status of canceled - udf | |
| • | Rows(i).interior.color = vbYellow ' highlights row i | |
| • | GetSignature | |
| • | Rows("1:1").RowHeight = 52.5 ' recorded | |
| • | Cells.Rows.Count | |
| • | HighlightTotalRow | |
| • | fr = Range("first_row").Row | |
| • | SQL insert rows from data | |
| • | ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded | |
| • | =IfERROR(VLOOKUP(INDIRECT(ADDRESS(ROW(),VLOOKUP($BW2,'Field To Use'!$H:$O,6,0))),'Rating Lookup'!$A:$B,2,0),0) | |
| • | Rows("9:34").EntireRow.AutoFit | |
| • | FindDataRow("string",col_nbr) | |
| • | Selection.Rows.Count | |
| • | Activecell.Row | |
| • | iif(num_rows = 20, 1, 0) - immediate if | |
| • | PivotFields("field_name").Orientation = xlRowField | |
| • | AR - sc for Activecell.row | |
| • | Down1 - sub to move activecell down 1 row sc | |
| • | Type fiilter_Fields row as Long column as Long End Type | |
| • | Rows, Columns and Cells | |
| • | Header Row | |
| • | pptshp.Table.Rows.count | |
| • | Browse | |
| • | Cells, Rows, Columns and Ranges | |
| • | Hidden Rows in Excel | |
| • | Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows) | |
| • | FindDataRowPartial(sSearch, c) as Long | |
| • | WrapEntireRowDelete |