Copy sheet from another workbook using VBA

[ElvisSteel]

Hi,

I have a workbook and I need to prompt the user for another workbook, then automtically copy an entire sheet from the selected workbook into the current workbook.
I am OK with the code to prompt and select another worksheet, but I am struggling with the code to do the copying of the entire sheet.

Can someone help please

Thanks

Steve

 

[ziad alsayed]

this a bit unclear. need more details.
there is no need to select the data when copying it.

is the data that you need to copy is normaly fix , i mean number of columns and rows.

there is no problem normally with the number of rows.

just give more details please. like the name of the two workbooks and the sheet of each

 

[ElvisSteel]

Thanks for your response and apologies for any confusion.

I have managed to work out what I was doing wrong, so sorry to have wasted your time

Regards

Steve

 

[ziad alsayed]

No problem