Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying sheets to new workbook, merged cell issue?
‘Alpha is a tab in another workbook (WBSEL) which is copied and pasted
in to a newly added workbook (via VBA). However this is an 1004 error relating to a merged cell (A1:J1). For some reason it won’t copy due to the merged cell? Why is this, the whole sheet is copied, why is it dependent on a cell? With WBAlpha .SaveAs Filename:="N:\mis\" & MyRange.Value & MyRange2.Value & "\" & "Alpha Figures" & " " & MyRange.Value & MyRange2.Value & ".xls" End With WBSEL.Activate Sheets("Alpha").Select Sheets("Alpha").Copy Befo=WBAlpha.Sheets(1) WBAlpha.Activate Sheets("Alpha").Paste Sheets("Sheet1").Select ActiveWindow.SelectedSheets.Delete Sheets("Sheet2").Select ActiveWindow.SelectedSheets.Delete Sheets("Sheet3").Select ActiveWindow.SelectedSheets.Delete With WBAlpha .SendMail Recipients:=Array(RngEmailTest2.Value, RngEmailTest.Value) .Close SaveChanges:=True Thanks, Simon (the MyRange.Value occurances are merely a date stamping for the previous month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color formatting issue when copying excel sheet from workbook to o | Excel Discussion (Misc queries) | |||
Copying data from workbook/sheets to another workbook/sheet | Excel Programming | |||
Issue with Hiding Sheets Depending on Workbook Name | Excel Programming | |||
Issue Copying Data from one workbook to another | Excel Programming | |||
Autofit Column Headers with wrapped text (Not a merged cell issue) | Excel Programming |