A kind soul helped me out with this the other day. Now I have a subsequent question: How do I set a variable to this value?
Here's what I'm trying to do:
Set MyFile = Workbooks(" & Range("B1") & " " & Range("C1") & ".xlsx")
so it would end up being:
Set MyFile = Workbooks(Donors April.xlsx)...