VBA With Block

Do you know the usage of With Block function in VBA?

Let's learn the usage of VBA With block.

Related: VBA Font

Related: Excel VBA common basic questions

VBA With Block:

Sometimes if you want to write code in which some character of the code is same in the all line, and at that time it becomes boring to write same code character again and again, in VBA you can solve this problem by using With Block.

Let's see an example, in the example given below.

You can run this in your VBA editor pane and save your time when you write lengthy scripts in VBA.

---

Written by: Kalpesh Agrawal (Actuarial Intern- IIB)