VBA ERROR: Cannot Paste the Selected Copied Content

[lazzarox2]

I have one open xls file and I am opening a second one to copy data from. 1. Last istruction does not paste the content. 2. If I want to copy 250 cells, when closing the file, how can I save the date in the memory? THANKS

Workbooks.Open ("C:\XLSX\1 (1)Output.xlsx")

Sheets("1(1).MatchType1").Select
Range("B2").Select
Range("B2:B101").Select

Selection.Copy

Workbooks("1 (1)Output.xlsx").Close
'Workbooks("RESULTS Tables 1 and 2.xlsx").Select
Sheets("Result 1").Select
Range("B3:cw3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True

 

[lazzarox2]

Anyone can help?

 

[Joe4]

Try pasting the data BEFORE closing the workbook.

 

[lazzarox2]

Hi. Thanks for your message. I did. But it seems I make a mistake to reactivate/ select the initial file. It blocks here now:
Workbooks("RESULTS Tables 1 and 2.xlsm").Select

 

[Joe4]

Can you please your complete code, as you have it now?
And please use Code Tags when posting code, for readability sake (see here: How to Post Your VBA Code).

 

[lazzarox2]

Does anyone know how to write in the macro the istruction Y or N for the above, after paste?

 

[lazzarox2]

Can you please your complete code, as you have it now?
And please use Code Tags when posting code, for readability sake (see here: How to Post Your VBA Code).

I solved it. Another issue now

 

[Joe4]

View attachment 108023
Does anyone know how to write in the macro the istruction Y or N for the above, after paste?

That is an entirely different question, and as such, she be posted in a brand new thread.