19/07/2015 - Within a With statement block, you can specify a member of the object starting with a period, as if the With statement object preceded it. 02/12/2018 - Once a With block is entered, object can't be changed. As a result, you can't use a single With statement to affect a number of different objects. A list of properties of the Font object in Excel VBA. Type a dot and then the name of the Font property in the above list that you want to change. The equal sign . Using with blocks can accelerate the process of running a macro. Instead writing a range, chart name, worksheet, etc. you can use with-blocks like below; 11/05/2016 - Even though this is an old question, I'd like to say something too. I had the same problem to get this error while using the .Find method. I came . A package manager for VBA. Based heavily on the design of the much-lauded package manager for Rust, Cargo, vba-blocks aims to make building projects with . 18/12/2018 - hello, I have the following code: Sub Macro1() ' ' Macro1 Macro ' ' 23/06/2019 - Objective. To debug the error 'Object variable or with block variable not set'. Approach. To understand this error, we have created 2 cases . Guide to VBA Comment Block. Here we learn 3 ways to comment in VBA which includes Using Apostrophe, Using Toolbar, Using REM Keyword, etc.