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 |
• | Range("range_name") | |
• | Concatenate a string to create a range | |
• | Assign a value to a cell - Range("xxx") = "a value" | |
• | Range vs. Cells | |
• | Select a cell - Range(...).select | |
• | Range(...).value | |
• | range(cl(c+1) & fr & ":" & cl(c+1) & r).select | |
• | Range("A1").select (dup) | |
• | Range(selection, selection.End(xlDown)).Select - select area - recorded | |
• | range(...).Autofilter Field:=1, criteria1:="=" & sValue, Operator:=xlAnd = recorded sets a filter | |
• | range("range_name").copy | |
• | Workbooks(thisworkbook.name).sheets("xxxx").Range("DER_cc") ' get the range name in another workbook | |
• | Display_the_columns - takes a spreadsheet and hides columns based on a range name - udf | |
• | ThisWorkbook.Sheets(....).Range(....) ' use when a different sheet is active | |
• | xl vs. VBA ranges | |
• | range names | |
• | ranges - "A1" "A1:C4" range_name | |
• | [cur_month_end] - access value in a range name | |
• | Range("A1:" & Cells(r,c).Address).Copy | |
• | fr = Range("first_row").Row | |
• | Selection.Autofill destination:=Range("H2:I" & r) | |
• | A01 IsRating - determines if a field is a rating range returns true/false | |
• | Range("Settings!datasource_type") = "SEC" | |
• | Workbooks(sWBK).Sheets("CPR_LIst").Range("portfolio") | |
• | DeleteExternalNames - deletes named ranges starting with External_ ' recorded | |
• | Range("A1").Listnames ' puts named ranges in A1 | |
• | Activesheet.Names(sName).Delete ' deletes a named range | |
• | As Excel.Range | |
• | align_ok_key(lKeyCol1 as Long, range1, lkeyCol2 as long, range2) - udf - 🔝 Aligns data from 2 sources | |
• | ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers | |
• | as Range | |
• | Activesheet.Shapes.Range(Array("Button 1")).Select | |
• | Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select | |
• | Named Range | |
• | PPT.ActiveWindow.Selection.SlideRange.SlideNumber - get the active slides # | |
• | pptshp.Table.Cell(i, 1).Shape.TextFrame.TextRange.Text - gets the text from a pptshp cell | |
• | Subscript out of range | |
• | Get Address of a Range name | |
• | Cells, Rows, Columns and Ranges | |
• | Range("C4") = Range("C4") | |
• | RemoveRangeNames - Removes ones with errors |