Hi all.
I am having a strange problem with the below code in that it produces the
run time error when trying to Paste the Selection.
However, if I perform the action manually in exactly the same way, as in
recording the macro in the first place, it works!?
How can I get this to run - it is after all, a really simple code. (Most
frustrating)
Thanks, Wes.


Windows("Transaction_Record.xlsm").Activate
Sheets("DETAILED_PMNTS_REC").Select
Range("N2077:QV2089").Select
Application.CutCopyMode = False
Selection.Copy
Windows("AUDIT_TRAIL.xlsm").Activate
Sheets("AUDIT_TRAIL_MONTHLY").Select
Range("B74").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks_:=False, Transpose:=False