copy column A-Z

**fairyme** · 10-01-2023, 06:13 AM

Hello,

I want to copy sheet to new file.
If I want copy column A-Z only.
Now my code as below?
How to edit it?

Please Login or Register  to view this content.

Thank you

**Huong7214** · 10-01-2023, 08:35 AM

Thử sửa đoạn code sau
SourceSheet.Copy Before:=DestWorkbook.Sheets(DestWorkbook.Sheets.Count)
thành
SourceSheet.rang("AZ1:AZ1000000").Copy Before:=DestWorkbook.Sheets(DestWorkbook.Sheets.Count).Range("A1")

**fairyme** · 10-01-2023, 08:45 PM

Now compile error in named argument not found.

How to solve it?

**jolivanes** · 10-01-2023, 09:11 PM

Maybe so?
Change references where required.

Please Login or Register  to view this content.

**jolivanes** · 10-01-2023, 09:55 PM

With finding "ter" or "pop" sheet.

Please Login or Register  to view this content.

Change the path and workbook name to be saved as.

copy column A-Z

LinkBack

Thread Tools

Rate This Thread

Display

copy column A-Z

Re: copy column A-Z

Re: copy column A-Z

Re: copy column A-Z

Re: copy column A-Z

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Insert a new column and copy the column with formula in the left column to the latest col

[SOLVED] Copy one column, but loop through a second column multiple times depending on first column

[SOLVED] Loop through Column B msgboxYesNo if Yes copy to Column C, if No copy to Column D

Copy data from sheet1 column with dynamic date, and copy data to second sheet column

How to Match a column with another sheet's column and copy paste the Entire Row&Column aft

Copy Column, Transpose Values into a row, clear column data-repeat copy in to next row

Vba - find next empty column, insert column, copy paste values & copy paste formulas

Bookmarks

Bookmarks

Posting Permissions