Hi Guys, I have an Excel Macro which opens a spreadsheet in the Cell "F7", then copies and pastes to another spreadsheet. See the code below. However, when I go Windows -> (so to return to the spreadsheet) how do I adapt it in the code?
Windows("01 - EMEA Mortgages Reporting Pack - Jan 15 (B) Test.xlsm").Activat
Open in new window
You can use the following code...