help with "invalid procedure call or argument" error.

I can't do an On Error Resume Next...

But you can add some 'real' error handling, such as it exists in VBA, so you can query the value of the various variables which may help you to figure out what's happening.

Also, just saying "I am getting 'invalid procedure call or argument' error" without saying which line errors limits the responses you're going to get...

But I do have the error sectioned bolded in the code, I failed to point that out though. I'll update

I know nothing about 'real' error handling. Error Resume Next is the extent that I know.

The bold text hardly stands out - it would have been much simpler to simply say which line.

I know nothing about 'real' error handling

I would strongly suggest you learn, or at least have a read of the link in my first reply. it's simple and has one major advantage - you can handle errors gracefully, and possibly correct them.

On Error Resume Next does not correct errors, it simply ignores them. All that happens is the errors can get compounded and the user is none the wiser. What if you were totalling the years Revenue Vs Costs? Revenue sums fine, the Costs calculation errors a few times. How popular would you be when the boss finds out the profit is not exactly what you calculated it to be?

Out of context, and not knowing anything about the values you are working with, I have no idea what the error is. I could guess but it would only be a guess.

I understand it doesn't stand out, that is why I said I should have pointed it out. And, I can read the link, but that doesn't really assist with my immediate need. I know I would be none the wiser, hence why I stated that I can't use Resume Next because it marks them as exported when they are not. If the error would flag the cell somehow and then continue on, then I could circle back around and fix (if I can figure out why it failed), As this code is for exporting as a PDF, then there is no totalling to be done wrong. Simply one file would not be exported with the others. Ideally exporting 250 sheets would not stop because ten rows in, one file name was wrong.

And as i mentioned, i can't provide a sample because it is personal and modifying it would likely modify the problem, I was looking more for a dumb down version of what that error meant so I could try and figure out the issue.

Norie, thanks. Yes that is where. And this is exporting 250 spreadsheets. It works on 238 of them. It is 12 sheets that do not work and they the exact same format and everything. I am trying to make a sample, but it is proving difficult

Norie, I attached a workbook to my first post.