Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Apologies in advance for the basic & clunky code!
I have a workbook containing columns of data and I want to copy and paste some of the columns into a new workbook, save and close it and continue with some other manipulations (all of which work fine). The problem I am having is that when I run the code, it does not error, but whilst it does the save and close, it doesn't paste anything into the new workbook. (even if I record the steps and paste the recorded macro into my code, it still doesn't do the paste) Columns("A:E").Select Selection.Copy Workbooks.Add Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveWorkbook.SaveAs Filename:=Worksheets("Notes").Range("auditpath").V alue & Workbooks("Original.xls").Worksheets("Notes").Rang e("audit") & ".xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False ActiveWindow.Close I feel I must be missing something obvious....? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cut and paste is not working in excel 2003 | Excel Discussion (Misc queries) | |||
Paste not working in Excel 07 | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Work Book Copied Into Word With Paste Special, Excel Workboo | Excel Discussion (Misc queries) | |||
paste special not working in excel | Excel Discussion (Misc queries) |