Need to copy columns H,K,L From one excel workbook to new workbook using Excel Macro
Posted
by
bhargav reddy
on Stack Overflow
See other posts from Stack Overflow
or by bhargav reddy
Published on 2013-10-25T21:50:51Z
Indexed on
2013/10/25
21:53 UTC
Read the original article
Hit count: 246
I have a excel workbook A.xlsx with columns A through T, now i need to copy specific columns H,K,L to a new workbook which would be created while i run a macro.
I was able to successfully copy a range of columns from one worksheet to another, but i am not finding a way to copy specific columns to a new workbook.
Private Sub copy_sub()
Sheets("Sheet1").Columns("H:K").Copy Sheets("Sheet2").Range("A1")
End Sub
© Stack Overflow or respective owner