Jan 26, 2021 · EXCEL VBA - RUN TIME ERROR '91': OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET Excel (Version 16.45 [microsoft 365]) macOS Big Sur Hi Geniuses! I'm trying …

May 26, 2021 · Use the debugger to see the different outcome when using SET and when missing it. Use "option explicit" to enforce you to think about what type of objects you are handling as you have …

Oct 27, 2013 · Could someone please tell me why I get an "object variable or with block variable not set" error when I run this code? Note: I do not get an error on first run of line.

Feb 4, 2025 · Excel VBA Object Variable or With Block Variable Not Set Error BeachDog_2600 Feb 19, 2025 B

Dec 27, 2016 · The macro works fine in that it finds and deletes all the lines but at the end, when it can't find another occurrence of the variable, it comes up with the error message: Run-time error '91'.

Apr 29, 2025 · In its current state, the code seems to break when an "X" is encountered, with the message "Run-time error '91': Object variable or With block variable not set", at this specific line:

Dec 19, 2023 · You are making reference to other variables and things in your code, but taken out of context, it is very hard for us to determine if you set all those correctly.

Jan 13, 2021 · VBA Error (but only on one sheet): Object variable or With block variable not set I'm using Excel in Microsoft Office 365 on Windows 10.

Feb 19, 2025 · Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Oct 9, 2017 · VBA troubleshooting: "Object variable or With block variable not set" How do I fix this?