Excel VBA: Loop through cells inside the used range (For Each Collection Loop)
Get the complete course here: https://courses.xelplus.com/p/excel-vba-excel-macros
In this video we do a mini project where we count the number of cells that contain formulas on our worksheet. We do this with Excel VBA with the help of the For Each Collection loop.
This allows us to loop through each cell inside the used range of the worksheet and check with the help of the IF statement whether or not we come across a formula cell. Here we use the HasFormula property of the range object. We then use a variable to keep this number in memory.
★★ Links to related videos: ★★
Copy/Paste in Excel VBA: https://youtu.be/p4ViTxIl0E0
Referencing Ranges with VBA: https://youtu.be/acGJb9Oojho
Learn about Visual Basic Editor: https://youtu.be/NpvvwrdDcQk
Recording macros: https://youtu.be/8IreWUk1Al4
Properties & methods in VBA: https://youtu.be/uYHrzo2gzbo
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#ExcelVBA
Видео Excel VBA: Loop through cells inside the used range (For Each Collection Loop) канала Leila Gharani
In this video we do a mini project where we count the number of cells that contain formulas on our worksheet. We do this with Excel VBA with the help of the For Each Collection loop.
This allows us to loop through each cell inside the used range of the worksheet and check with the help of the IF statement whether or not we come across a formula cell. Here we use the HasFormula property of the range object. We then use a variable to keep this number in memory.
★★ Links to related videos: ★★
Copy/Paste in Excel VBA: https://youtu.be/p4ViTxIl0E0
Referencing Ranges with VBA: https://youtu.be/acGJb9Oojho
Learn about Visual Basic Editor: https://youtu.be/NpvvwrdDcQk
Recording macros: https://youtu.be/8IreWUk1Al4
Properties & methods in VBA: https://youtu.be/uYHrzo2gzbo
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#ExcelVBA
Видео Excel VBA: Loop through cells inside the used range (For Each Collection Loop) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)Excel Macro Class 3 - Looping through Ranges & Working with CellsExcel VBA basics: Data types, DIM & SET (Learn to use them correctly)Excel VBA Basics #10 - Looping through a database and analyzing cells based on criteriaHow to Create & Use Excel Macros (Real world example)How to get the Last Row in VBA(The Right Way!)Excel VBA Introduction Part 17 - For Each LoopsExcel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)7 Things You're Doing WRONG in ExcelVBA loops, nested loops basicFree Excel VBA Course #19 - FOR EACH Loop in Excel VBAReturn Multiple Match Results in Excel (2 methods)Excel Productivity for Lazy (but Smart) PeopleFree Excel VBA Course #17 - Do While and Do Until Loop in Excel VBAExcel VBA tutorial for beginners: Object Properties & MethodsLooping through the Cells in a Range in Excel VBA (Macro) - Code IncludedHow to Use Arrays Instead of Ranges in Excel VBAExcel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook