Object variables

Please see the attached file. This is a sheet I created that has all my company vendor information on it (Deleted all info for security). At the top I made buttons with the letters of the alphabet in them. You can hit the button you want and it will take you to the corresponding location in the field of vendors. This sheet works most of the day and then for an unknown reason (to me) it will pop up the "Object variable or With block variable not set" error. I dont know that much about VBA... PLEASE HELP!!

I might be missing something, but is the code in another workbook?

'\\hou-cf-02\homedir\jmerrel\Excel Files\1 - DXP Daily\2 - Item Inquiry.xls'!FindA

There doesn't appear to be any code in the example you have posted. Is it possiblt that the macro fails because someone has opened the source workbook?

Regards, TMS

The code to select the alphabetic entry looks OK, if a little repetitive.

Your print code could be a little slicker, for example:

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

Could just be:

Please Login or Register  to view this content.

And:

Please Login or Register  to view this content.

could be:

Please Login or Register  to view this content.

Similarly

Please Login or Register  to view this content.

could be:

Please Login or Register  to view this content.

The only thing I can think of is that an error occurs in another part of the code that resets some variable(s).


I appreciate that you had to take out the sensitive data but it's difficult to test stuff without representative information.

All the code is range specific so I'm not entirely sure if or how it works when you add entries into a range.


Sorry, I can't be more help at the moment.

Regards, TMS