Run-time error '438'

Hello

I have the following VBA coding in my workbook. It was working fine but now I'm getting a Run time error 438 message "Object doesn't support this property or method". It lets me choose "end" and will then continue to print the worksheet, but I need the workbook to be fully working before I can let it loose on my colleagues! I know that some people will get a bit freaked by a run time error message!

I have no idea where to start looking for the error that's making this message appear as the run time error message box is greying out the debug button.

If anyone can help me, I'd really appreciate it.

Any changes to the coding need to be compatible with excel versions 2003, 2007 & 2010.

Many thanks.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is the VBA module password protected? Could explain why you're not getting a debug option...


To stick a band aid over it....add:

Please Login or Register  to view this content.

In fact, putting in a resume next could be your only way to find the problem. Stick the resume next at the top and run the macro, if it works then move the resume next further down in the macro and try again. Rinse and repeat until you get the error, the line of code directly above the resume next will be the one causing the problem.

yes the VBA module is password protected. I need everything protected as it's going to be used by over 2000 employees and I don't want any forumulae or coding changed as it's for an expense claim form. Only certain cells are to be completed.

If I take the VBA password off, I now get an error at line:

Please Login or Register  to view this content.

Try this code:

Please Login or Register  to view this content.

Thanks for the tip Swoop99 - that makes sense!

& Thanks for the coding Gerard - works perfectly now.