Run-time error 1004 when trying to load UserForm

Hello Jasoncw,

Is InputAuditors a named range? If so, change your code to this...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks for the reply, Leith.

Yes, it is a named range, but unfortunately, that did not change anything. Any other ideas? I will hesitantly post my workbook if needed.

Hello jasoncw,

I gather you have some sensitive information in the workbook. If you can "clean" it then post it that would help. If time is factor, you could email it to me and I will post the corrections made here in the forum.

Sincerely,
Leith Ross

Thanks again, Leith.

I believe I solved the problem. This was a snip from a different file, and apparently in the other file, I was using the variable Aud as an array. So I was getting the error here:

Please Login or Register  to view this content.

Since it is a range variable, I changed it to:

Please Login or Register  to view this content.

All is good now. Thanks again.

Jason