Macro question

[Citrusandsage]

I have a an excel file that is a statement for commissions and a data validation list of employees that I filter on when I am trying to export to a PDF when doing macros. I record , filter on each employee name, I copy the name of the person in the formula bar > export to PDF And paste the name as the file name and save into the corresponding folder. However, when I run the macros I have this glitch where one of the names that I copied gets pasted into a cell in the Excel statement and then saves multiple employees PDFs as that name and I cannot figure out why it’s doing that. do I need to physically type the persons name as the file name and not copy and paste? I haven’t tested this out yet because I’m dealing with over 200 employees so I figured I would ask if anybody knows of this glitch and what do I do to fix it?

 

[Micron]

Maybe post the problem code and something might be figured out. You should not have to manually type; copy/paste should be good enough. It's good enough for some of the macros you have, yes? This is likely more of a code bug than a glitch.

If you post code, please paste within code tags (use VBA button on posting toolbar) to maintain indentation and readability.

 

[Citrusandsage]

Yess it’s not everyone only happens on some. I’ll see if I can post the code.