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 |
| • | Insert a column - Columns(lCol).EntireColumn.Insert ' recorded | |
| • | Hardcoding column number problem | |
| • | Add Columns to a report | |
| • | Move columns on a report | |
| • | Hide columns or rows on a report | |
| • | Findlastrow - udf - finds the last row in a column | |
| • | mixing up row and column error | |
| • | Select a column - Columns(i).select | |
| • | Columns - basic | |
| • | Columns("A:A").ColumnWidth = 7.43 - recorded | |
| • | FindLastCol(1) - find the last column passed a row udf | |
| • | ColumnWidthToPixels - internet code | |
| • | ColumnWidthToPixels - internet code (Data accuracy report) | |
| • | displaycolumns - udf | |
| • | Add Columns to a Report Manually Maintained | |
| • | Display_the_columns - takes a spreadsheet and hides columns based on a range name - udf | |
| • | Columns(1).select - selects a column | |
| • | lcol = Finddatacol("column header fields",1) ' avoid hardcoding by searching for a column | |
| • | Columns.("A:E").EntireColumn.AutoFit | |
| • | Selection.EntireColumn.Hidden = True ' recorded | |
| • | selection.PasteSpecial Paste:=xlPasteColumnWidths, ..' recorded | |
| • | col variables - stores the number of a column which is retrieved via FindDataCol in case column moves (Hardcoding) | |
| • | Columns("A:P").clear | |
| • | Error handling Logic - column doesn't exist | |
| • | Create a Sheet with a number of columns to run queries and process Excel output | |
| • | Columns("H:I").NumberFormat = "#,##0" | |
| • | ColumnLetter - udf - converts a column # to a column letter | |
| • | ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded | |
| • | AddRatingColumns | |
| • | ActiveSheet.PivotTables("pt1").ColumnGrand = True ' recorded | |
| • | Activecell.Column | |
| • | Type fiilter_Fields row as Long column as Long End Type | |
| • | Rows, Columns and Cells | |
| • | pptshp.table.Columns.Count | |
| • | Hide columns that confuse user (hide or grouping) | |
| • | Cells, Rows, Columns and Ranges | |
| • | Column references |