Y
YoureNotAtHomeNow
Hello All
I want to select a worksheet from a workbook, open a new workbook and
paste the worksheet into it. Almost all will be 'paste formulas' but
I want to be able, if possible, to paste some values instead in
certain cells. VBA beginner, so I've tried to do it with the record
method. Resulting macro copies the worksheet to the clipboard ok, but
then pastes it back into the same worksheet instead of a new workbook.
I want to select a worksheet from a workbook, open a new workbook and
paste the worksheet into it. Almost all will be 'paste formulas' but
I want to be able, if possible, to paste some values instead in
certain cells. VBA beginner, so I've tried to do it with the record
method. Resulting macro copies the worksheet to the clipboard ok, but
then pastes it back into the same worksheet instead of a new workbook.