Completed
Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel VBA & Macros Tutorials
Automatically move to the next video in the Classroom when playback concludes
- 1 Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)
- 2 Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
- 3 Excel VBA tutorial for beginners: Object Properties & Methods
- 4 Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)
- 5 Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)
- 6 Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)
- 7 Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)
- 8 Excel VBA: Loop through cells inside the used range (For Each Collection Loop)
- 9 How to use the Message Box in Excel VBA (syntax you'll need for msgbox)
- 10 Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook
- 11 Excel VBA FIND Function (& how to handle if value NOT found)
- 12 Excel ActiveX Combo Box to Select Worksheets with VBA
- 13 Link Page Header to Cell Value with Excel VBA
- 14 Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder
- 15 Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
- 16 3 Methods to Unhide All Sheets in Excel (& how to hide)
- 17 Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)
- 18 Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA
- 19 How to SUM Cells by Color in Excel (Get it to update automatically)
- 20 VBA to BROWSE & COPY Data from SELECTED File in Excel
- 21 Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)
- 22 How to create barcodes in Excel that WORK!
- 23 How to Create & Use Excel Macros (Real world example)
