how to copy a range from a specific worksheet

hi guys,
sorry but i am a n00b in regards to code writing. i want the following code to be changed in such a way that the sheet2 of ws=activesheet is selected. how do i do this?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

how can i combine this with the active sheet command? like that?? the shorter the better coz it is a long vba code and cpu is working hard

Please Login or Register  to view this content.

What is wh? Is this a sheet in ws?

yes wh is another workbook

can anyone experienced help me on this plz. thanks

Workbook is not worksheet. In your code, you set ws as a worksheet, but in 3th sentence, you use it as a workbook. So, what actually are ws and wh?