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 |
| • | R1C1 option | |
| • | range names | |
| • | Range vs. Cells | |
| • | Range("A1").Listnames ' puts named ranges in A1 | |
| • | Range("A1").select (dup) | |
| • | Range("A1:" & Cells(r,c).Address).Copy | |
| • | Range("C4") = Range("C4") | |
| • | Range("range_name") | |
| • | range("range_name").copy | |
| • | Range("Settings!datasource_type") = "SEC" | |
| • | range(...).Autofilter Field:=1, criteria1:="=" & sValue, Operator:=xlAnd = recorded sets a filter | |
| • | Range(...).value | |
| • | range(cl(c+1) & fr & ":" & cl(c+1) & r).select | |
| • | Range(selection, selection.End(xlDown)).Select - select area - recorded | |
| • | ranges - "A1" "A1:C4" range_name | |
| • | ReadOnly | |
| • | RealGo - udf db - detmine if a go in sql is the real one | |
| • | Recording a Macro and Generalizing it | |
| • | Recursion | |
| • | Redim Preserve a(r -2) | |
| • | Redundancy Problem | |
| • | Refactor - coding technique | |
| • | Refactor code - that can be Table Driven | |
| • | Reference Active DS Type Library | |
| • | Reference to Microsoft Data Objects 2.8 Library | |
| • | Reference to Microsoft Forms 2.0 Object Library | |
| • | Reference to Windows Script Host Object Model | |
| • | reference value in an array aSuffixes(i) | |
| • | References - MSXML2.XLMHTTP60 | |
| • | Regular Expressions (see Save as PDF) | |
| • | Release Notes | |
| • | Remove filtered data but keep filters | |
| • | Remove people from email who are no longer at your company | |
| • | RemoveCanceled - Removes rows with a status of canceled - udf | |
| • | RemoveLastComma | |
| • | RemoveRangeNames - Removes ones with errors | |
| • | RemoveSQLComments - udf | |
| • | RenameFiles | |
| • | Replace | |
| • | Restore Point | |
| • | Resume Next or Label - Error Handling | |
| • | RetrieveDataToSheet - udf - db | |
| • | Retrieving Data from a Webpage using Sendkeys | |
| • | Return a value from a function | |
| • | Return multiple values from a function by returning a comma separated sting and parsing the results | |
| • | Returning a value(s) from a sub | |
| • | RGB(x,y,z) - vba color func where x, y , z are # from 1 - 255 | |
| • | Right(string,n) - string function | |
| • | Right1 - udf - move activecell 1 to the right | |
| • | Round - function | |
| • | Rows - basic | |
| • | Rows collection | |
| • | Rows("1:1").RowHeight = 52.5 ' recorded | |
| • | Rows("1:1").select 'a row | |
| • | Rows("9:34").EntireRow.AutoFit | |
| • | Rows(i).hidden | |
| • | Rows(i).interior.color = vbYellow ' highlights row i | |
| • | Rows, Columns and Cells | |
| • | rs.Close | |
| • | rs.fields(i).name | |
| • | rs.MoveNext | |
| • | rt - udf - Response Time | |
| • | rt = udf to track Response Time (optimize) | |
| • | RTrim - VBA func | |
| • | Run "Thisworkbook.WorkBook_Open" | |
| • | Run a Macro with Parameters | |
| • | Run a query sample | |
| • | Run SQL and save output to a sequential file | |
| • | Run SQL from a file | |
| • | Run('c:\filename.xlsm'!Button2_click") | |
| • | Run | |
| • | Running a batch and opening a new spreadsheet Issue - IgnoreRemotedde | |
| • | RunProgram "http.." (File Associations need to set up) | |
| • | RunQuery( ) - udf db - runs a query that returns 1 value and not a recordset | |
| • | runquery2 - udf - runs a query that returns 2 values | |
| • | RunSQLFromFile - udf - db 🔝 | |
| • | RunTheQuery - udf - db |