Hi,

I've recorded a macro to copy a range of cells (Q6:Q26) from a different open workbook ("Control Area Sheet Test.xls") and paste the values into a different cell range (T104:T124) in the workbook that I activated the macro in ("TBA TEAM LIST (3).xls").

Is it possible to have the module copy from 'Control Area Sheet Test.xls' without the file being open?
I've come across the 'GetValuesFromAClosedWorkbook' function, but I'm not sure how to use this to copy a cell range to the clipboard.

Any help would be most appriciated!

Sub UpdateAircraftPic()
'
' UpdateAircraftPic Macro
' Macro recorded 12/06/2013 by ULHREN0
'

'
    Windows("Control Area Sheet Test.xls").Activate
    Range("Q6:Q26").Copy
    Windows("TBA TEAM LIST (3).xls").Activate
    Range("T104:T124").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
End Sub