macro that copies information from a worksheet from workbook A then opens a new workbook a

Hello.
I am new to VBA.
I am trying to make a macro that copies information from a worksheet from workbook A then opens a new workbook and copies the information as value only(no formulas)
Unfortunately I get stuck in the stage of pasting the values.
Attached is the relevant code of the macro.
Please note: the macro gets stuck in the following line “Worksheets(1).Range("a1").PasteSpecial xlPasteValues”
[/I]
Here is the code:
wkb.Activate
Sheets("swimmer").Select
ActiveSheet.Copy
Set wkb_new = Workbooks.Add
wkb_new.Worksheets(1).Activate
wkb_new.Worksheets(1).Select
Worksheets(1).Range("a1").PasteSpecial xlPasteValues



Your help is appreciated.
Have a nice day

Hi starlev and welcome to the forums where an amazing bunch of volunteers generously give of their spare time to help others, yes even though it may not be immediately obvious, most of us do have "real jobs"

SO, firstly, please take the time to read the forum rules, they are not onerous and are designed to make helping you easier for everybody who sees your problem post.

Secondly, if AT ALL possible please attach a sample spreadsheet with your inputs and expected results AND the code you have tried so far. As I mentioned, we are all volunteers and the task of having to dream up a spreadsheet that may or may not look like yours is often enough to make us say "this post is too hard" and just bypass your question altogether

Thirdly, please (as the rules ask) use the code tags (click on the "#" icon on the toolbar for the posts). It keeps the formatting and makes it easy for us to see what you are doing in the code

I am guessing that your problem resolution is actually very simple

jmac1947