Answer the question
In order to leave comments, you need to log in
How to transfer data to the next sheet with a macro?
VBA saw today for the first time. Please help me find the error. Here is the code:
Cells(1, 1).Select
Selection.Copy
Sheets("list2").Select
Cells(1, 2).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Answer the question
In order to leave comments, you need to log in
No, with the syntax, the order worked for me without errors.
And why does he swear, maybe instead of "list2" write "Sheet2"?
It will be useful to use macro recording
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question