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 |