Hi,
I feel really stupid asking this question but I cannot get this part of my macro to work.

In essence, I am opening one file that contains data that I need to copy to 50 other files (paste special values to the same location in all 50 files).

I open the source file (it is always the same name and located in the same folder).

mfileprs = Cells(mstart, 2) & Cells(mstart, 3)
        Workbooks.Open FileName:=Chr(34) & mfileprs & Chr(34)
        
       Windows("Exchange Rates.xlsx").Activate
        Worksheets("Sheet1").Range("A1:B9").Copy
        
        Windows(mfileprs).Activate
        Worksheets("Rates").Range("AA1:AB9").PasteSpecial Paste:=xlPasteValues
It does not like Windows(mfileprs).Activate but using this same variable to open the file works fine.

What is it that I'm not understanding