M
M
Maxim Timofeev2015-09-09 16:41:37
Database
Maxim Timofeev, 2015-09-09 16:41:37

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

Apparently the syntax suffers. In my understanding, the following code should take cell 1-1 and move it to another sheet in 1-2, but it doesn't work.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Fedoryan, 2015-09-09
@webinar

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 question

Ask a Question

731 491 924 answers to any question