Error 91 VBA

Thanks!, how did you realize that was the problem?

I just stepped in your code to track where it is failed. Because you are trying to open the form but having a code to unload the form via Userform Load evert. So again when the code completes the initialisation (Also Closing of Userform Also) and coming back to open the form then again the loading event triggers the same activity...

In fact i would prefer the form never shows up

Instead of

ydhBulkForm.Show

Use

Load ydhBulkForm
Unload ydhBulkForm