ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro Runtime Error (https://www.excelbanter.com/excel-discussion-misc-queries/51085-macro-runtime-error.html)

Dave 2005

macro Runtime Error
 
Hi

I have a macro that will run ok about 5 times out of 10. I would like to
know why this is happening

Run-time error '91': object variable or with block variable not set.

Thanks in advance




JE McGimpsey

macro Runtime Error
 
It's because you're trying to use an object variable that isn't set.

Anything more would require that you post the macro.

In article ,
"Dave 2005" wrote:

Hi

I have a macro that will run ok about 5 times out of 10. I would like to
know why this is happening

Run-time error '91': object variable or with block variable not set.

Thanks in advance



All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com