Copy from one workbook to another

**chrisellis250** · 06-20-2019, 06:04 AM

Hello all,

I have the following code, to copy from one workbook to another:

Please Login or Register  to view this content.

The issue I have is around the sht2.Cells.Copy.Range ("AD27:AJ27") line, which is copying the whole sheet instead of the range...where am I going wrong?

Many thanks,

Chris

**mohadin** · 06-20-2019, 07:08 AM

Try

sht2.Range ("AD27:AJ27").copy

**Fluff13** · 06-20-2019, 08:46 AM

Or avoiding the clipboard

Please Login or Register  to view this content.

Copy from one workbook to another

LinkBack

Thread Tools

Rate This Thread

Display

Copy from one workbook to another

Re: Copy from one workbook to another

Re: Copy from one workbook to another

Thread Information

Users Browsing this Thread

Similar Threads

Copy HTM Files from Closed Workbook and Copy to Active Workbook if Sheet Name=File Name

[SOLVED] VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

Assign name to Workbook, Copy range from one workbook to another workbook

Copy data one workbook to another workbook without opening workbook

[SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names

[SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference

loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook

Bookmarks

Bookmarks

Posting Permissions