589689.xyz

[] Udemy - Excel VBA Programming - The Complete Guide

  • 收录时间:2020-02-24 22:03:48
  • 文件大小:2GB
  • 下载次数:84
  • 最近下载:2021-01-01 15:30:13
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 14. Functions/4. The Is Family of Functions.mp4 79MB
  2. 7. Object Deep Dive/7. The Workbook.SaveAs and Workbook.Save Methods.mp4 56MB
  3. 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.mp4 50MB
  4. 7. Object Deep Dive/2. The Application.DisplayAlerts Property.mp4 47MB
  5. 8. Range References/14. The Range.Rows and Range.Columns Properties.mp4 45MB
  6. 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.mp4 44MB
  7. 7. Object Deep Dive/8. The Workbook.Activate Method.mp4 42MB
  8. 7. Object Deep Dive/11. The Worksheets.Add Method.mp4 40MB
  9. 7. Object Deep Dive/4. The Workbooks.Open Method and Workbook.Path Property.mp4 37MB
  10. 12. Miscellaneous Features/4. StatusBar.mp4 37MB
  11. 7. Object Deep Dive/13. The Worksheet.Visible Property.mp4 35MB
  12. 7. Object Deep Dive/6. The Workbooks.Add Method.mp4 35MB
  13. 7. Object Deep Dive/9. The Workbook.Close Method.mp4 33MB
  14. 14. Functions/6. More Date and Time Functions.mp4 30MB
  15. 14. Functions/5. Date and Time Functions.mp4 30MB
  16. 16. Events/1. Introduction to Events.mp4 29MB
  17. 7. Object Deep Dive/14. The Worksheet.Copy Method.mp4 29MB
  18. 1. Getting Started/6. The Macro Recorder.mp4 28MB
  19. 9. Range Actions/12. The Range.Copy and Range.Cut Methods.mp4 28MB
  20. 3. The Visual Basic Editor/5. The MsgBox Method.mp4 26MB
  21. 11. Iteration/1. The For Next Loop.mp4 26MB
  22. 7. Object Deep Dive/1. The Application Object.mp4 25MB
  23. 7. Object Deep Dive/16. The Worksheet.Move Method.mp4 24MB
  24. 2. The Fundamentals of the Excel Object Model/5. The Excel Object Model.mp4 24MB
  25. 9. Range Actions/5. The Range.Sort Method.mp4 24MB
  26. 1. Getting Started/1. Introduction.mp4 23MB
  27. 6. Procedures/7. Predefined Constants.mp4 22MB
  28. 7. Object Deep Dive/15. The Worksheet.Delete Method.mp4 22MB
  29. 10. Conditionals/5. Select Case.mp4 21MB
  30. 10. Conditionals/4. The ElseIf and Else Statements.mp4 20MB
  31. 4. Objects and Methods/3. Methods with Arguments.mp4 20MB
  32. 17. User Forms/17. The CheckBox Control.mp4 20MB
  33. 2. The Fundamentals of the Excel Object Model/1. Object-Oriented Programming in Real Life.mp4 20MB
  34. 11. Iteration/8. Exit For and Review of Exit Sub.mp4 20MB
  35. 17. User Forms/14. The ListBox Control III - Select Multiple Items.mp4 19MB
  36. 16. Events/4. The Worksheet_Change Event.mp4 19MB
  37. 9. Range Actions/3. The Range.TextToColumns Method.mp4 19MB
  38. 5. Variables and Data Types/2. Variable Declarations and Assignments.mp4 19MB
  39. 8. Range References/3. R1C1 Notation, Part I.mp4 18MB
  40. 13. Arrays/6. Dynamic Arrays.mp4 18MB
  41. 17. User Forms/16. The ComboBox Control II.mp4 18MB
  42. 1. Getting Started/5. Macro Security.mp4 17MB
  43. 9. Range Actions/6. The Range.Font Property.mp4 17MB
  44. 3. The Visual Basic Editor/1. Visual Basic Editor Options.mp4 17MB
  45. 17. User Forms/9. Submit the UserForm.mp4 17MB
  46. 1. Getting Started/9. Absolute vs. Relative References II.mp4 17MB
  47. 4. Objects and Methods/7. Ways to Invoke A Procedure.mp4 16MB
  48. 15. Debugging/4. Error and Err.Number.mp4 16MB
  49. 14. Functions/1. VBA Functions, Part I.mp4 16MB
  50. 3. The Visual Basic Editor/4. The Immediate Window and Debug.Print Method.mp4 16MB
  51. 11. Iteration/3. Deleting Rows.mp4 16MB
  52. 8. Range References/1. The Range.Select Method.mp4 16MB
  53. 1. Getting Started/10. The Visual Basic Editor.mp4 16MB
  54. 2. The Fundamentals of the Excel Object Model/4. Objects As Properties.mp4 16MB
  55. 1. Getting Started/3. Enable the Developer Tab.mp4 16MB
  56. 3. The Visual Basic Editor/2. Create and Delete a Procedure.mp4 15MB
  57. 1. Getting Started/8. Absolute vs. Relative References I.mp4 15MB
  58. 14. Functions/8. Custom Functions.mp4 15MB
  59. 17. User Forms/13. The ListBox Control II - React to User Selection.mp4 15MB
  60. 5. Variables and Data Types/14. The Object Data Type.mp4 15MB
  61. 11. Iteration/5. The For Each-Next Construct.mp4 15MB
  62. 8. Range References/4. R1C1 Notation, Part II.mp4 15MB
  63. 5. Variables and Data Types/1. Syntax Tips.mp4 15MB
  64. 12. Miscellaneous Features/8. The Application.InputBox Method.mp4 14MB
  65. 7. Object Deep Dive/3. The Workbooks.Count and Worksheets.Count Properties.mp4 14MB
  66. 6. Procedures/3. Procedures with Arguments.mp4 14MB
  67. 10. Conditionals/8. The NOT Operator.mp4 14MB
  68. 11. Iteration/2. The Step Keyword.mp4 14MB
  69. 16. Events/7. Workbook Events and The Sh Argument.mp4 13MB
  70. 6. Procedures/1. Variable Scope.mp4 13MB
  71. 6. Procedures/4. Procedure Scope (Public vs. Private).mp4 13MB
  72. 5. Variables and Data Types/5. The Byte, Integer and Long Data Types.mp4 13MB
  73. 15. Debugging/2. The OnError and GoTo Keywords.mp4 13MB
  74. 17. User Forms/12. The ListBox Control I - Wire up the Form.mp4 13MB
  75. 9. Range Actions/7. The Range.Interior Property.mp4 13MB
  76. 8. Range References/5. The Formula and FormulaR1C1 Properties.mp4 13MB
  77. 4. Objects and Methods/5. Methods with Multiple Arguments.mp4 13MB
  78. 17. User Forms/8. Unload and Hide a UserForm.mp4 13MB
  79. 10. Conditionals/6. The AND & OR Logical Operators.mp4 13MB
  80. 16. Events/2. The Worksheet_SelectionChange Event.mp4 12MB
  81. 14. Functions/7. Excel Worksheet Functions.mp4 12MB
  82. 8. Range References/11. The Range.End Property.mp4 12MB
  83. 12. Miscellaneous Features/7. The InputBox Function.mp4 12MB
  84. 15. Debugging/1. Intro to Error Handling.mp4 12MB
  85. 9. Range Actions/8. The Range.ColumnWidth and Range.RowHeight Properties.mp4 12MB
  86. 5. Variables and Data Types/12. The Date Data Type.mp4 12MB
  87. 8. Range References/16. Get Last Row of Data in Worksheet.mp4 12MB
  88. 15. Debugging/5. Stepping Through Code.mp4 12MB
  89. 4. Objects and Methods/6. The Object Browser.mp4 12MB
  90. 6. Procedures/6. Constants.mp4 11MB
  91. 17. User Forms/11. The initialize Event.mp4 11MB
  92. 13. Arrays/4. Initialize Arrays within a For Loop.mp4 11MB
  93. 9. Range Actions/11. The Range.Delete Method.mp4 11MB
  94. 11. Iteration/7. The With-End With Construct.mp4 11MB
  95. 17. User Forms/1. Create UserForm, Toolbox, Properties, Controls.mp4 11MB
  96. 11. Iteration/6. Iterating over a Range of Cells with For Each.mp4 10MB
  97. 2. The Fundamentals of the Excel Object Model/3. Collection Objects in Real Life.mp4 10MB
  98. 10. Conditionals/1. Boolean Expressions.mp4 10MB
  99. 5. Variables and Data Types/8. The Single and Double Data Types.mp4 10MB
  100. 5. Variables and Data Types/13. The Variant Data Type.mp4 10MB
  101. 5. Variables and Data Types/7. Mathematical Operations.mp4 10MB
  102. 4. Objects and Methods/8. The TypeName Method.mp4 10MB
  103. 15. Debugging/3. The OnError Resume Next Keywords.mp4 10MB
  104. 3. The Visual Basic Editor/6. Comments.mp4 10MB
  105. 8. Range References/10. The Range.CurrentRegion Property.mp4 10MB
  106. 17. User Forms/15. The ComboBox Control I.mp4 10MB
  107. 13. Arrays/5. The LBound and UBound Methods.mp4 10MB
  108. 7. Object Deep Dive/5. The Workbooks.Close Method.mp4 10MB
  109. 14. Functions/2. VBA Functions, Part II.mp4 10MB
  110. 17. User Forms/5. Design Aesthetics.mp4 10MB
  111. 9. Range Actions/1. The Range.FillDown Method.mp4 9MB
  112. 17. User Forms/2. The Label and TextBox Controls.mp4 9MB
  113. 8. Range References/6. The Range.Offset Property.mp4 9MB
  114. 9. Range Actions/13. The Paste and PasteSpecial Methods on the Worksheet Object.mp4 9MB
  115. 9. Range Actions/2. The Range.Replace Method.mp4 9MB
  116. 15. Debugging/6. Breakpoints.mp4 9MB
  117. 8. Range References/9. The Cells Property.mp4 9MB
  118. 5. Variables and Data Types/9. The String Data Type.mp4 8MB
  119. 12. Miscellaneous Features/6. SpecialCells.mp4 8MB
  120. 14. Functions/3. The Split Function.mp4 8MB
  121. 1. Getting Started/4. Excel File Types.mp4 8MB
  122. 5. Variables and Data Types/3. Multiple Variable Declarations.mp4 8MB
  123. 13. Arrays/7. The Range.RemoveDuplicates Method.mp4 8MB
  124. 17. User Forms/7. Add Event Procedure to Control.mp4 8MB
  125. 13. Arrays/1. Intro to Arrays.mp4 8MB
  126. 9. Range Actions/10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.mp4 8MB
  127. 2. The Fundamentals of the Excel Object Model/6. Access Object from Collection by Name.mp4 7MB
  128. 5. Variables and Data Types/4. The Option Explicit Setting.mp4 7MB
  129. 2. The Fundamentals of the Excel Object Model/8. The Name Property on Workbook and Worksheet Objects.mp4 7MB
  130. 9. Range Actions/14. The Parent Property on All Objects.mp4 7MB
  131. 17. User Forms/6. The CommandButton Control.mp4 7MB
  132. 5. Variables and Data Types/11. The Boolean Data Type.mp4 7MB
  133. 8. Range References/2. The Value vs. Text Properties.mp4 7MB
  134. 10. Conditionals/3. The If Then Statement.mp4 7MB
  135. 2. The Fundamentals of the Excel Object Model/7. Default Properties.mp4 7MB
  136. 6. Procedures/2. Call A Procedure from Another one.mp4 7MB
  137. 8. Range References/12. The Range.Count and Range.CountLarge Properties.mp4 6MB
  138. 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.mp4 6MB
  139. 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.mp4 6MB
  140. 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.mp4 6MB
  141. 16. Events/9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.mp4 6MB
  142. 9. Range Actions/9. The Range.AutoFit Method.mp4 6MB
  143. 16. Events/8. The Workbook_Open Event.mp4 6MB
  144. 17. User Forms/10. Activate a UserForm from Procedure.mp4 6MB
  145. 8. Range References/15. The Range.EntireRow and Range.EntireColumn Properties.mp4 6MB
  146. 8. Range References/7. The Range.Resize Property.mp4 5MB
  147. 16. Events/3. Review of Application.EnableEvents.mp4 5MB
  148. 4. Objects and Methods/1. Methods without Arguments.mp4 5MB
  149. 5. Variables and Data Types/15. Default Values for Declared Variables.mp4 5MB
  150. 17. User Forms/3. Naming Conventions.mp4 5MB
  151. 8. Range References/13. The Range.Row and Range.Column Properties.mp4 4MB
  152. 16. Events/5. The Worksheet_Activate Event.mp4 4MB
  153. 9. Range Actions/4. The Range.Worksheet Property.mp4 4MB
  154. 6. Procedures/5. The Exit Sub Keywords.mp4 3MB
  155. 1. Getting Started/2.1 vba-course.zip.zip 2MB
  156. 1. Getting Started/6. The Macro Recorder.srt 27KB
  157. 2. The Fundamentals of the Excel Object Model/5. The Excel Object Model.srt 25KB
  158. 3. The Visual Basic Editor/1. Visual Basic Editor Options.srt 23KB
  159. 11. Iteration/1. The For Next Loop.srt 23KB
  160. 16. Events/4. The Worksheet_Change Event.srt 23KB
  161. 3. The Visual Basic Editor/5. The MsgBox Method.srt 23KB
  162. 9. Range Actions/5. The Range.Sort Method.srt 22KB
  163. 1. Getting Started/1. Introduction.srt 21KB
  164. 11. Iteration/8. Exit For and Review of Exit Sub.srt 21KB
  165. 2. The Fundamentals of the Excel Object Model/1. Object-Oriented Programming in Real Life.srt 20KB
  166. 14. Functions/8. Custom Functions.srt 19KB
  167. 11. Iteration/3. Deleting Rows.srt 19KB
  168. 10. Conditionals/4. The ElseIf and Else Statements.srt 19KB
  169. 6. Procedures/7. Predefined Constants.srt 19KB
  170. 14. Functions/4. The Is Family of Functions.srt 18KB
  171. 17. User Forms/16. The ComboBox Control II.srt 18KB
  172. 10. Conditionals/5. Select Case.srt 18KB
  173. 7. Object Deep Dive/7. The Workbook.SaveAs and Workbook.Save Methods.srt 17KB
  174. 17. User Forms/17. The CheckBox Control.srt 17KB
  175. 6. Procedures/1. Variable Scope.srt 17KB
  176. 13. Arrays/6. Dynamic Arrays.srt 17KB
  177. 8. Range References/3. R1C1 Notation, Part I.srt 17KB
  178. 17. User Forms/14. The ListBox Control III - Select Multiple Items.srt 16KB
  179. 12. Miscellaneous Features/8. The Application.InputBox Method.srt 16KB
  180. 1. Getting Started/10. The Visual Basic Editor.srt 16KB
  181. 12. Miscellaneous Features/7. The InputBox Function.srt 16KB
  182. 5. Variables and Data Types/2. Variable Declarations and Assignments.srt 16KB
  183. 14. Functions/1. VBA Functions, Part I.srt 16KB
  184. 9. Range Actions/3. The Range.TextToColumns Method.srt 16KB
  185. 9. Range Actions/6. The Range.Font Property.srt 16KB
  186. 1. Getting Started/5. Macro Security.srt 15KB
  187. 3. The Visual Basic Editor/4. The Immediate Window and Debug.Print Method.srt 15KB
  188. 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.srt 15KB
  189. 17. User Forms/9. Submit the UserForm.srt 15KB
  190. 15. Debugging/5. Stepping Through Code.srt 15KB
  191. 3. The Visual Basic Editor/2. Create and Delete a Procedure.srt 15KB
  192. 14. Functions/7. Excel Worksheet Functions.srt 15KB
  193. 4. Objects and Methods/3. Methods with Arguments.srt 15KB
  194. 8. Range References/11. The Range.End Property.srt 15KB
  195. 8. Range References/1. The Range.Select Method.srt 15KB
  196. 17. User Forms/11. The initialize Event.srt 14KB
  197. 16. Events/7. Workbook Events and The Sh Argument.srt 14KB
  198. 17. User Forms/12. The ListBox Control I - Wire up the Form.srt 14KB
  199. 8. Range References/4. R1C1 Notation, Part II.srt 14KB
  200. 4. Objects and Methods/7. Ways to Invoke A Procedure.srt 14KB
  201. 1. Getting Started/8. Absolute vs. Relative References I.srt 14KB
  202. 10. Conditionals/8. The NOT Operator.srt 14KB
  203. 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.srt 13KB
  204. 5. Variables and Data Types/5. The Byte, Integer and Long Data Types.srt 13KB
  205. 2. The Fundamentals of the Excel Object Model/4. Objects As Properties.srt 13KB
  206. 1. Getting Started/9. Absolute vs. Relative References II.srt 13KB
  207. 15. Debugging/4. Error and Err.Number.srt 13KB
  208. 5. Variables and Data Types/1. Syntax Tips.srt 13KB
  209. 15. Debugging/1. Intro to Error Handling.srt 13KB
  210. 5. Variables and Data Types/14. The Object Data Type.srt 13KB
  211. 16. Events/1. Introduction to Events.srt 13KB
  212. 17. User Forms/1. Create UserForm, Toolbox, Properties, Controls.srt 13KB
  213. 11. Iteration/5. The For Each-Next Construct.srt 13KB
  214. 17. User Forms/13. The ListBox Control II - React to User Selection.srt 12KB
  215. 6. Procedures/3. Procedures with Arguments.srt 12KB
  216. 11. Iteration/7. The With-End With Construct.srt 12KB
  217. 11. Iteration/2. The Step Keyword.srt 12KB
  218. 7. Object Deep Dive/4. The Workbooks.Open Method and Workbook.Path Property.srt 12KB
  219. 4. Objects and Methods/5. Methods with Multiple Arguments.srt 12KB
  220. 1. Getting Started/3. Enable the Developer Tab.srt 12KB
  221. 15. Debugging/2. The OnError and GoTo Keywords.srt 12KB
  222. 9. Range Actions/7. The Range.Interior Property.srt 12KB
  223. 8. Range References/14. The Range.Rows and Range.Columns Properties.srt 12KB
  224. 7. Object Deep Dive/2. The Application.DisplayAlerts Property.srt 12KB
  225. 10. Conditionals/6. The AND & OR Logical Operators.srt 12KB
  226. 6. Procedures/4. Procedure Scope (Public vs. Private).srt 12KB
  227. 14. Functions/2. VBA Functions, Part II.srt 12KB
  228. 7. Object Deep Dive/8. The Workbook.Activate Method.srt 12KB
  229. 6. Procedures/6. Constants.srt 11KB
  230. 17. User Forms/8. Unload and Hide a UserForm.srt 11KB
  231. 13. Arrays/1. Intro to Arrays.srt 11KB
  232. 9. Range Actions/8. The Range.ColumnWidth and Range.RowHeight Properties.srt 11KB
  233. 11. Iteration/6. Iterating over a Range of Cells with For Each.srt 11KB
  234. 10. Conditionals/1. Boolean Expressions.srt 11KB
  235. 8. Range References/5. The Formula and FormulaR1C1 Properties.srt 11KB
  236. 15. Debugging/6. Breakpoints.srt 11KB
  237. 12. Miscellaneous Features/4. StatusBar.srt 11KB
  238. 13. Arrays/5. The LBound and UBound Methods.srt 11KB
  239. 16. Events/2. The Worksheet_SelectionChange Event.srt 11KB
  240. 9. Range Actions/11. The Range.Delete Method.srt 11KB
  241. 8. Range References/16. Get Last Row of Data in Worksheet.srt 11KB
  242. 5. Variables and Data Types/4. The Option Explicit Setting.srt 10KB
  243. 17. User Forms/15. The ComboBox Control I.srt 10KB
  244. 14. Functions/6. More Date and Time Functions.srt 10KB
  245. 7. Object Deep Dive/6. The Workbooks.Add Method.srt 10KB
  246. 5. Variables and Data Types/7. Mathematical Operations.srt 10KB
  247. 5. Variables and Data Types/12. The Date Data Type.srt 10KB
  248. 5. Variables and Data Types/8. The Single and Double Data Types.srt 10KB
  249. 4. Objects and Methods/8. The TypeName Method.srt 10KB
  250. 17. User Forms/5. Design Aesthetics.srt 10KB
  251. 13. Arrays/4. Initialize Arrays within a For Loop.srt 10KB
  252. 12. Miscellaneous Features/6. SpecialCells.srt 10KB
  253. 4. Objects and Methods/6. The Object Browser.srt 10KB
  254. 15. Debugging/3. The OnError Resume Next Keywords.srt 9KB
  255. 5. Variables and Data Types/13. The Variant Data Type.srt 9KB
  256. 7. Object Deep Dive/13. The Worksheet.Visible Property.srt 9KB
  257. 7. Object Deep Dive/11. The Worksheets.Add Method.srt 9KB
  258. 3. The Visual Basic Editor/6. Comments.srt 9KB
  259. 2. The Fundamentals of the Excel Object Model/3. Collection Objects in Real Life.srt 9KB
  260. 5. Variables and Data Types/9. The String Data Type.srt 9KB
  261. 17. User Forms/7. Add Event Procedure to Control.srt 9KB
  262. 9. Range Actions/1. The Range.FillDown Method.srt 9KB
  263. 17. User Forms/2. The Label and TextBox Controls.srt 9KB
  264. 9. Range Actions/13. The Paste and PasteSpecial Methods on the Worksheet Object.srt 9KB
  265. 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.srt 8KB
  266. 9. Range Actions/2. The Range.Replace Method.srt 8KB
  267. 8. Range References/10. The Range.CurrentRegion Property.srt 8KB
  268. 8. Range References/6. The Range.Offset Property.srt 8KB
  269. 14. Functions/5. Date and Time Functions.srt 8KB
  270. 8. Range References/9. The Cells Property.srt 8KB
  271. 7. Object Deep Dive/9. The Workbook.Close Method.srt 8KB
  272. 14. Functions/3. The Split Function.srt 7KB
  273. 9. Range Actions/14. The Parent Property on All Objects.srt 7KB
  274. 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.srt 7KB
  275. 13. Arrays/7. The Range.RemoveDuplicates Method.srt 7KB
  276. 7. Object Deep Dive/1. The Application Object.srt 7KB
  277. 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.srt 7KB
  278. 5. Variables and Data Types/11. The Boolean Data Type.srt 7KB
  279. 10. Conditionals/3. The If Then Statement.srt 7KB
  280. 9. Range Actions/10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.srt 7KB
  281. 5. Variables and Data Types/3. Multiple Variable Declarations.srt 7KB
  282. 6. Procedures/2. Call A Procedure from Another one.srt 7KB
  283. 2. The Fundamentals of the Excel Object Model/8. The Name Property on Workbook and Worksheet Objects.srt 7KB
  284. 1. Getting Started/4. Excel File Types.srt 7KB
  285. 16. Events/9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.srt 7KB
  286. 9. Range Actions/12. The Range.Copy and Range.Cut Methods.srt 7KB
  287. 2. The Fundamentals of the Excel Object Model/6. Access Object from Collection by Name.srt 7KB
  288. 7. Object Deep Dive/14. The Worksheet.Copy Method.srt 7KB
  289. 17. User Forms/6. The CommandButton Control.srt 6KB
  290. 17. User Forms/10. Activate a UserForm from Procedure.srt 6KB
  291. 16. Events/3. Review of Application.EnableEvents.srt 6KB
  292. 8. Range References/2. The Value vs. Text Properties.srt 6KB
  293. 8. Range References/7. The Range.Resize Property.srt 6KB
  294. 17. User Forms/3. Naming Conventions.srt 6KB
  295. 2. The Fundamentals of the Excel Object Model/7. Default Properties.srt 6KB
  296. 4. Objects and Methods/1. Methods without Arguments.srt 6KB
  297. 8. Range References/12. The Range.Count and Range.CountLarge Properties.srt 5KB
  298. 7. Object Deep Dive/16. The Worksheet.Move Method.srt 5KB
  299. 9. Range Actions/9. The Range.AutoFit Method.srt 5KB
  300. 16. Events/8. The Workbook_Open Event.srt 5KB
  301. 5. Variables and Data Types/15. Default Values for Declared Variables.srt 5KB
  302. 16. Events/5. The Worksheet_Activate Event.srt 5KB
  303. 8. Range References/15. The Range.EntireRow and Range.EntireColumn Properties.srt 5KB
  304. 7. Object Deep Dive/15. The Worksheet.Delete Method.srt 4KB
  305. 8. Range References/13. The Range.Row and Range.Column Properties.srt 4KB
  306. 7. Object Deep Dive/3. The Workbooks.Count and Worksheets.Count Properties.srt 4KB
  307. 9. Range Actions/4. The Range.Worksheet Property.srt 4KB
  308. 6. Procedures/5. The Exit Sub Keywords.srt 3KB
  309. 7. Object Deep Dive/5. The Workbooks.Close Method.srt 3KB
  310. 1. Getting Started/2. Download Course Materials.html 1KB
  311. 12. Miscellaneous Features/3. MsgBox Options.html 1KB
  312. 17. User Forms/4. Naming Conventions.html 686B
  313. 1. Getting Started/8.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html 186B
  314. 4. Objects and Methods/1.1 Office VBA Reference - Understanding Objects, Properties, Methods, and Events.html 181B
  315. 1. Getting Started/4.1 Office Support - File formats that are supported in Excel.html 179B
  316. 1. Getting Started/5.1 Office Support - Change macro security settings in Excel.html 178B
  317. 1. Getting Started/6.1 Getting Started with VBA in Office - To record a macro.html 177B
  318. 5. Variables and Data Types/4.1 Official MSDN Documentation for the Option Explicit Statement.html 169B
  319. 3. The Visual Basic Editor/1.1 Official MSDN Article on Configuring Options in the Visual Basic Editor.html 166B
  320. 2. The Fundamentals of the Excel Object Model/7.1 Stack Overflow - Is “Value” actually the default property of the Range object.html 164B
  321. 5. Variables and Data Types/1.1 Official MSDN Documentation for Understanding Visual Basic Syntax.html 163B
  322. 1. Getting Started/3.1 Office Support - Show the Developer tab.html 161B
  323. 12. Miscellaneous Features/7.1 Official Microsoft documentation for the InputBox Function.html 161B
  324. 5. Variables and Data Types/1.2 Official MSDN Documentation for Writing Visual Basic Statements.html 161B
  325. 5. Variables and Data Types/11.1 Official MSDN Documentation for the Boolean Data Type.html 161B
  326. 5. Variables and Data Types/5.2 Official MSDN Documentation for the Integer Data Type.html 161B
  327. 5. Variables and Data Types/2.2 Official MSDN Documentation for Writing Declaration Statements.html 160B
  328. 5. Variables and Data Types/8.1 Official MSDN Documentation for the Single Data Type.html 160B
  329. 5. Variables and Data Types/8.2 Official MSDN Documentation for the Double Data Type.html 160B
  330. 5. Variables and Data Types/9.1 Official MSDN Documentation for the String Data Type.html 160B
  331. 1. Getting Started/1.2 Getting Started with VBA in Office.html 159B
  332. 11. Iteration/5.1 Official MSDN Article on Using For Each Next Statements.html 159B
  333. 5. Variables and Data Types/2.4 Official MSDN Documentation for Writing Assignment Statements.html 159B
  334. 1. Getting Started/1.1 What's New for VBA in Office 2016.html 158B
  335. 10. Conditionals/5.1 Official MSDN Article on Using Select Case Statements.html 158B
  336. 11. Iteration/8.1 Official MSDN Reference on the Exit Statement.html 158B
  337. 12. Miscellaneous Features/5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html 158B
  338. 14. Functions/8.1 Official MSDN Article on Writing A Function Procedure.html 158B
  339. 5. Variables and Data Types/12.1 Official MSDN Documentation for the Date Data Type.html 158B
  340. 5. Variables and Data Types/2.5 Official MSDN Documentation for Using Data Types Efficiently.html 158B
  341. 5. Variables and Data Types/5.1 Official MSDN Documentation for the Byte Data Type.html 158B
  342. 5. Variables and Data Types/5.3 Official MSDN Documentation for the Long Data Type.html 158B
  343. 6. Procedures/5.1 Official MSDN Documentation on the Exit Statement.html 158B
  344. 10. Conditionals/4.1 Official MSDN Article on Using If...Then...Else Statements.html 157B
  345. 12. Miscellaneous Features/1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html 157B
  346. 7. Object Deep Dive/2.1 Official MSDN Documentation for the Application.DisplayAlerts Property.html 157B
  347. 16. Events/3.1 Official MSDN Documentation for the Application.EnableEvents Property.html 156B
  348. 1. Getting Started/10.2 MSDN - Use the Properties Window.html 155B
  349. 10. Conditionals/6.2 Official MSDN Reference on the AND Operator.html 155B
  350. 10. Conditionals/8.1 Official MSDN Reference on the NOT Operator.html 155B
  351. 5. Variables and Data Types/2.3 Official MSDN Documentation for Visual Basic Naming Rules.html 155B
  352. 1. Getting Started/10.1 MSDN - Use the Immediate Window.html 154B
  353. 1. Getting Started/10.3 MSDN - Use the Project Explorer.html 154B
  354. 10. Conditionals/6.1 Official MSDN Reference on the OR Operator.html 154B
  355. 11. Iteration/1.1 Official MSDN Article on Using For Next Statements.html 154B
  356. 16. Events/2.1 Official MSDN Documentation for the Worksheet.SelectionChange Event.html 154B
  357. 2. The Fundamentals of the Excel Object Model/4.1 Dummies.com - An Overview of the Excel Object Model.html 154B
  358. 2. The Fundamentals of the Excel Object Model/5.1 Dummies.com - An Overview of the Excel Object Model.html 154B
  359. 3. The Visual Basic Editor/4.2 Official MSDN Article on Using the Immediate Window.html 154B
  360. 12. Miscellaneous Features/4.1 Official MSDN Documentation for the Application.StatusBar Property.html 153B
  361. 3. The Visual Basic Editor/2.1 Official MSDN Article on Writing a Procedure.html 153B
  362. 4. Objects and Methods/6.1 Official MSDN Article on using the Object Browser.html 152B
  363. 5. Variables and Data Types/13.1 Official MSDN Article on Understanding Variants.html 152B
  364. 6. Procedures/7.2 Official MSDN Documentation for the xlPageOrientation Enumeration.html 152B
  365. 7. Object Deep Dive/1.4 Official MSDN Documentation for the Application.UserName Property.html 152B
  366. 7. Object Deep Dive/13.1 Official MSDN Documentation for the XlSheetVisibility Enumeration.html 152B
  367. 9. Range Actions/13.2 Official MSDN Documentation for the Worksheet.PasteSpecial Method.html 152B
  368. 11. Iteration/7.1 Official MSDN Article on Using With Statements.html 151B
  369. 7. Object Deep Dive/1.6 Official MSDN Documentation for the Application.Version Property.html 151B
  370. 8. Range References/10.1 Official Documentation for the Range.CurrentRegion Property.html 151B
  371. 9. Range Actions/7.1 Official MSDN Documentation for the Interior.ColorIndex Property.html 151B
  372. 12. Miscellaneous Features/8.1 Official MSDN Documentation for the Application.InputBox Method.html 150B
  373. 8. Range References/15.2 Official Documentation for the Range.EntireColumn Property.html 150B
  374. 9. Range Actions/14.4 Official MSDN Documentation for the Application.Parent Property.html 150B
  375. 16. Events/7.1 Official MSDN Documentation for the Workbook.SheetChange Event.html 149B
  376. 16. Events/9.1 Official MSDN Documentation for the Workbook.BeforePrint Event.html 149B
  377. 5. Variables and Data Types/2.1 Official MSDN Documentation for Declaring Variables.html 149B
  378. 6. Procedures/6.2 Official MSDN Article on Declaring Constants.html 149B
  379. 7. Object Deep Dive/13.2 Official MSDN Documentation for the Worksheet.Visible Property.html 149B
  380. 8. Range References/5.1 Official MSDN Documentation for the Range.FormulaR1C1 Property.html 149B
  381. 9. Range Actions/10.3 Official MSDN Documentation for the Range.ClearContents Method.html 149B
  382. 9. Range Actions/8.1 Official MSDN Documentation for the Range.ColumnWidth Property.html 149B
  383. 12. Miscellaneous Features/6.1 Official MSDN Documentation for the Range.SpecialCells Method.html 148B
  384. 14. Functions/4.4 Tech on the Net Article on the IsNumeric Function.html 148B
  385. 7. Object Deep Dive/1.1 Official MSDN Documentation for the Application.Name Property.html 148B
  386. 7. Object Deep Dive/1.2 Official MSDN Documentation for the Application.Path Property.html 148B
  387. 7. Object Deep Dive/3.1 Official MSDN Documentation for the Worksheets.Count Property.html 148B
  388. 9. Range Actions/10.1 Official MSDN Documentation for the Range.ClearFormats Method.html 148B
  389. 9. Range Actions/14.2 Official MSDN Documentation for the Worksheet.Parent.html 148B
  390. 16. Events/5.1 Official MSDN Documentation for the Worksheet.Activate Event.html 147B
  391. 4. Objects and Methods/3.2 Official MSDN Documentation for the Worksheet.Protect Method.html 147B
  392. 4. Objects and Methods/8.1 Official MSDN Documentation for the TypeName Function.html 147B
  393. 7. Object Deep Dive/3.2 Official MSDN Documentation for the Workbooks.Count Property.html 147B
  394. 7. Object Deep Dive/7.2 Official MSDN Documentation for the XlFileFormat Enumeration.html 147B
  395. 7. Object Deep Dive/8.1 Official MSDN Documentation for the Workbook.Activate Method.html 147B
  396. 8. Range References/15.1 Official Documentation for the Range.EntireRow Property.html 147B
  397. 9. Range Actions/14.1 Official MSDN Documentation for the Workbook.Parent Property.html 147B
  398. 9. Range Actions/8.2 Official MSDN Documentation for the Range.RowHeight Property.html 147B
  399. 13. Arrays/1.1 Official MSDN Article on Declaring Arrays.html 146B
  400. 13. Arrays/7.1 Official MSDN Documentation for the Range.RemoveDuplicates Method.html 146B
  401. 14. Functions/4.1 Tech on the Net Article on the IsError Function.html 146B
  402. 14. Functions/4.3 Tech on the Net Article on the IsEmpty Function.html 146B
  403. 2. The Fundamentals of the Excel Object Model/8.2 Official MSDN Documentation for the Worksheet.Name Property.html 146B
  404. 7. Object Deep Dive/1.5 Official MSDN Documentation for the Application.Quit Method.html 146B
  405. 7. Object Deep Dive/15.1 Official MSDN Documentation for the Worksheet.Delete Method.html 146B
  406. 8. Range References/11.1 Official Documentation for the XlDirection Enumeration.html 146B
  407. 9. Range Actions/13.3 Official MSDN Documentation for the XlPasteType Enumeration.html 146B
  408. 9. Range Actions/7.2 Official MSDN Documentation for the Range.Interior Property.html 146B
  409. 14. Functions/4.2 Tech on the Net Article on the IsDate Function.html 145B
  410. 16. Events/4.1 Official MSDN Documentation for the Worksheet.Change Event.html 145B
  411. 2. The Fundamentals of the Excel Object Model/8.1 Official MSDN Documentation for the Workbook.Name Property.html 145B
  412. 6. Procedures/6.1 Official MSDN Article on Using Constants.html 145B
  413. 7. Object Deep Dive/4.2 Official MSDN Documentation for the Workbook.Path Property.html 145B
  414. 7. Object Deep Dive/5.1 Official MSDN Documentation for the Workbooks.Close Method.html 145B
  415. 7. Object Deep Dive/7.1 Official MSDN Documentation for the Workbook.SaveAs Method.html 145B
  416. 8. Range References/14.2 Official Documentation for the Range.Columns Property.html 145B
  417. 8. Range References/5.2 Official MSDN Documentation for the Range.Formula Property.html 145B
  418. 9. Range Actions/13.1 Official MSDN Documentation for the Worksheet.Paste Method.html 145B
  419. 7. Object Deep Dive/11.2 Official MSDN Documentation for the Worksheets.Add Method.html 144B
  420. 7. Object Deep Dive/14.1 Official MSDN Documentation for the Worksheet.Copy Method.html 144B
  421. 7. Object Deep Dive/16.1 Official MSDN Documentation for the Worksheet.Move Method.html 144B
  422. 7. Object Deep Dive/4.1 Official MSDN Documentation for the Workbooks.Open Method.html 144B
  423. 7. Object Deep Dive/9.1 Official Documentation for the Workbook.Close Method.html 144B
  424. 8. Range References/13.1 Official Documentation for the Range.Column Property.html 144B
  425. 8. Range References/6.1 Official MSDN Documentation for the Range.Offset Property.html 144B
  426. 8. Range References/7.1 Official MSDN Documentation for the Range.Resize Property.html 144B
  427. 9. Range Actions/1.1 Official MSDN Documentation for the Range.FillDown Method.html 144B
  428. 9. Range Actions/14.3 Official MSDN Documentation for the Range.Parent Property.html 144B
  429. 7. Object Deep Dive/6.1 Official MSDN Documentation for the Workbooks.Add Method.html 143B
  430. 7. Object Deep Dive/7.4 Official MSDN Documentation for the Workbook.Save Method.html 143B
  431. 8. Range References/12.1 Official Documentation for the Range.Count Property.html 143B
  432. 8. Range References/2.2 Official MSDN Documentation for the Range.Value Property.html 143B
  433. 8. Range References/9.1 Official MSDN Documentation for the Application.Cells Property.html 143B
  434. 9. Range Actions/3.1 Official MSDN Documentation for the Range.TextToColumns.html 143B
  435. 9. Range Actions/9.1 Official MSDN Documentation for the Range.AutoFit Method.html 143B
  436. 13. Arrays/1.2 Official MSDN Article on Using Arrays.html 142B
  437. 16. Events/8.1 Official MSDN Documentation for the Workbook.Open Event.html 142B
  438. 3. The Visual Basic Editor/4.1 Official MSDN Article on the Debug Object.html 142B
  439. 8. Range References/14.1 Official Documentation for the Range.Rows Property.html 142B
  440. 8. Range References/2.1 Official MSDN Documentation for the Range.Text Property.html 142B
  441. 9. Range Actions/11.1 Official MSDN Documentation for the Range.Delete Method.html 142B
  442. 7. Object Deep Dive/1.3 Official MSDN Documentation for the Application Object.html 141B
  443. 8. Range References/11.2 Official Documentation for the Range.End Property.html 141B
  444. 8. Range References/13.2 Official Documentation for the Range.Row Property.html 141B
  445. 9. Range Actions/10.2 Official MSDN Documentation for the Range.Clear Method.html 141B
  446. 9. Range Actions/4.1 Official MSDN Documentation for the Range.Worksheet Property.html 141B
  447. 7. Object Deep Dive/11.1 Official MSDN Documentation for the Worksheets Object.html 140B
  448. 9. Range Actions/12.1 Official MSDN Documentation for the Range.Copy Method.html 140B
  449. 4. Objects and Methods/3.1 Official MSDN Documentation for the Worksheet Object.html 139B
  450. 6. Procedures/7.1 Official MSDN Documentation for the PageSetup Object.html 139B
  451. 7. Object Deep Dive/13.3 Official MSDN Documentation for the Worksheet Object.html 139B
  452. 7. Object Deep Dive/3.3 Official MSDN Documentation for the Workbooks Object.html 139B
  453. 9. Range Actions/12.2 Official MSDN Documentation for the Range.Cut Method.html 139B
  454. 7. Object Deep Dive/7.3 Official MSDN Documentation for the Workbook Object.html 138B
  455. 9. Range Actions/7.3 Official MSDN Documentation for the Interior Object.html 138B
  456. 9. Range Actions/2.1 Official MSDN Documentation for the Range.Replace Method.html 137B
  457. 8. Range References/1.2 Official MSDN Documentation for the Range.Select Method.html 136B
  458. 1. Getting Started/4.2 Wikipedia - List of Microsoft Office filename extensions.html 135B
  459. 8. Range References/1.1 Official MSDN Documentation for the Range Object.html 135B
  460. 1. Getting Started/7. Record Macro to Change Worksheet Orientation.html 134B
  461. 11. Iteration/4. Fill Empty Rows.html 134B
  462. 16. Events/6. Highlight Row and Column Up to Cell Where Cursor Is Placed.html 134B
  463. 2. The Fundamentals of the Excel Object Model/2. Real Life Objects.html 134B
  464. 3. The Visual Basic Editor/7. Practice with Procedures.html 134B
  465. 4. Objects and Methods/2. Methods without Arguments.html 134B
  466. 4. Objects and Methods/4. Methods with Arguments.html 134B
  467. 5. Variables and Data Types/16. Variable Declarations.html 134B
  468. 5. Variables and Data Types/6. Numeric Data Types.html 134B
  469. 7. Object Deep Dive/12. Add a New Worksheet to End of Current List of Worksheets.html 134B
  470. 9. Range Actions/5.1 Official MSDN Documentation for the Range.Sort Method.html 134B
  471. 9. Range Actions/6.1 Official MSDN Documentation for the Font Object.html 134B
  472. 1. Getting Started/11. VBA Basics.html 132B
  473. 10. Conditionals/2. Boolean Expressions.html 132B
  474. 10. Conditionals/7. Logical Operators.html 132B
  475. 11. Iteration/9. Iteration.html 132B
  476. 2. The Fundamentals of the Excel Object Model/9. Object-Oriented Programming.html 132B
  477. 3. The Visual Basic Editor/3. Procedures.html 132B
  478. 3. The Visual Basic Editor/8. The Visual Basic Editor.html 132B
  479. 4. Objects and Methods/9. Objects and Methods.html 132B
  480. 5. Variables and Data Types/10. String and Double Data Types.html 132B
  481. 6. Procedures/8. Procedures.html 132B
  482. 7. Object Deep Dive/10. The Application, Workbooks and Workbook Objects.html 132B
  483. 8. Range References/8. The Offset and Resize Properties.html 132B
  484. 3. The Visual Basic Editor/6.1 Official MSDN Tutorial on Adding Comments to Code.html 125B
  485. 3. The Visual Basic Editor/5.1 Official MSDN Reference Article on the MsgBox Method.html 124B
  486. 14. Functions/6.9 Tech on the Net Article on the WeekdayName Function.html 120B
  487. 14. Functions/5.1 Tech on the Net Article on the DateSerial Function.html 119B
  488. 14. Functions/1.1 Complete Listing of all VBA Functions.html 118B
  489. 14. Functions/2.1 Complete Listing of all VBA Functions.html 118B
  490. 14. Functions/6.4 Tech on the Net Article on the MonthName Function.html 118B
  491. 14. Functions/5.2 Tech on the Net Article on the Date Function.html 117B
  492. 10. Conditionals/3.1 Article How to use the IF-THEN-ELSE Statement.html 116B
  493. 14. Functions/6.1 Tech on the Net Article on the Weekday Function.html 116B
  494. 14. Functions/6.2 Tech on the Net Article on the Minute Function.html 115B
  495. 14. Functions/6.8 Tech on the Net Article on the Second Function.html 115B
  496. 14. Functions/3.1 Tech on the Net Article on the VBA Split Function.html 114B
  497. 14. Functions/6.5 Tech on the Net Article on the Month Function.html 114B
  498. 14. Functions/6.3 Tech on the Net Article on the Year Function.html 113B
  499. 14. Functions/6.6 Tech on the Net Article on the Hour Function.html 113B
  500. 14. Functions/5.3 Tech on the Net Article on the Now Function.html 112B
  501. 14. Functions/6.7 Tech on the Net Article on the Day Function.html 112B
  502. [DesireCourse.Net].url 51B
  503. [CourseClub.Me].url 48B