PasteSpecial in VBA Code No Longer Working

So ... this code was working in February ... but now I get the error message "run-time error '1004': PasteSpecial method of Range class failed"

Instead of pasting the copied cells, it appears to just insert one blank cell (shifting that column down).

I went through step by step and the macro is selecting and copying the correct cells, and moving back to the correct worksheet and location ... it's just the PasteSpecial that is not working.

Please Login or Register  to view this content.

Any suggestions?

I think I am attaching the files below (I did some replacing to make possibly identifying information gibberish).

The Committees spreadsheet is the main sheet, where the macro is. Google Doc Download is where the info to populate the main sheet comes from. Let me know if there is something else you would need.

Module8. Line 37 (Selection.PasteSpecial Paste:=xlPasteValues).

Yes, it's clunky. But it was doing what it needed to. Now, it is not (for me, apparently). The "Role1" question used to also come up for me, but I do not get there now.

When I run through line by line, and paste into a separate Excel document after running line 36, the correct items paste, but I get the warning "The range you are pasting contains formulas that cannot be pasted into this instance of Excel; however, the formulas will be pasted as values. This may result from pasting values from Protected View, another instance of Excel or from another application." When I try going to Paste Special, it indicates that I am trying to paste a "Microsoft Excel Worksheet (code) object" that I can paste as a picture, Bitmap, etc., but not as values. So this seems to be the problem (because my macro is trying to paste values).