How to use With and Nested with Statement (With – End With) in VBA Programming | Learn in 5 Minutes
In this video you will learn how to reduce efforts while writing VBA code when you are dealing with the same object in each line with the help of With Statement
How to refer to Excel cell in VBA - • How to refer to Excel cell in VBA| Ho...
How to play with fonts in Excel with VBA Programming - • How to play with fonts in Excel with ...
Timestamps
00:00 - Intro
00:57 - Where to write the code
01:43 - Writing the code
02:04 - Example without "With Statement"
04:57 - With Statement
07:03 - Nested With Statement
08:12 - Closure
play_arrow
How to find duplicate values from data in excel before removing them | Learn in 5 Minutes
play_arrow
How to use Nested Xlookup to build two-way lookup in Microsoft Excel | Learn in 5 Minutes