Application.Run Error When Using A Variable to Run Macro In Another Sheet

Hello!

I am new to VBA and having trouble using a variable to run a macro in another sheet. The macro I'm trying to run is called "bride". It copies a range in a sheet that I want to paste in my active sheet. When I try to run the code below, I get a syntax error for the "Application.Run" command and I haven't been able to figure out what I'm doing wrong after much trial and error! I also tried defining the "copyWB" variable as a workbook, but couldn't get that to work either.

Thanks for any help!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

because there are spaces in the workbook name

please copy and paste the exact code you tried

that's still not actually what I posted-no spaces before or after the single quotes

are you sure your workbook and sheet names are correct?

Please Login or Register  to view this content.

not better just a different approach ;-)