Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range and formats to new Workbook
Hi,
does any one now how copy range A1:T33 to a new workbook with all it's format ColumnWidth, Rowheight and colours etc. It should be run from a commandbutton AHA Ole_ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range and formats to new Workbook
The easiest way (in my opinion, of course) would be to copy the sheet and
clear the unwanted data Private Sub CommandButton1_Click() Me.copy activesheet.Range("34:65536").EntireRow.Delete activesheet.Range("V:IV").EntireColumn.Delete Application.DisplayAlerts = False ActiveWorkbook.SaveAs "C:\MyFolder\Newfile.xls" Application.DisplayAlerts = True End Sub -- Regards, Tom Ogilvy "ole_" wrote in message ... Hi, does any one now how copy range A1:T33 to a new workbook with all it's format ColumnWidth, Rowheight and colours etc. It should be run from a commandbutton AHA Ole_ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range and formats to new Workbook
Yes, but my problem is that there is 13 comamandbuttons and some other code
that i dont want to be transfered to the new woorkbook. "Tom Ogilvy" skrev i en meddelelse ... The easiest way (in my opinion, of course) would be to copy the sheet and clear the unwanted data Private Sub CommandButton1_Click() Me.copy activesheet.Range("34:65536").EntireRow.Delete activesheet.Range("V:IV").EntireColumn.Delete Application.DisplayAlerts = False ActiveWorkbook.SaveAs "C:\MyFolder\Newfile.xls" Application.DisplayAlerts = True End Sub -- Regards, Tom Ogilvy "ole_" wrote in message ... Hi, does any one now how copy range A1:T33 to a new workbook with all it's format ColumnWidth, Rowheight and colours etc. It should be run from a commandbutton AHA Ole_ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range and formats to new Workbook
Private Sub CommandButton1_Click()
Workbooks.Add Application.Activeworkbook.Worksheets(1).Name = "Other" With Application.ActiveWorkbook.Worksheets("Other") me.cells.copy Destination:=.Range("A1") .Range("34:65536").EntireRow.Delete .Range("V:IV").EntireColumn.Delete Application.DisplayAlerts = False .Parent.SaveAs "C:\MyFolder\Newfile.xls" Application.DisplayAlerts = True End With End Sub -- Regards, Tom Ogilvy "ole_" wrote in message ... Yes, but my problem is that there is 13 comamandbuttons and some other code that i dont want to be transfered to the new woorkbook. "Tom Ogilvy" skrev i en meddelelse ... The easiest way (in my opinion, of course) would be to copy the sheet and clear the unwanted data Private Sub CommandButton1_Click() Me.copy activesheet.Range("34:65536").EntireRow.Delete activesheet.Range("V:IV").EntireColumn.Delete Application.DisplayAlerts = False ActiveWorkbook.SaveAs "C:\MyFolder\Newfile.xls" Application.DisplayAlerts = True End Sub -- Regards, Tom Ogilvy "ole_" wrote in message ... Hi, does any one now how copy range A1:T33 to a new workbook with all it's format ColumnWidth, Rowheight and colours etc. It should be run from a commandbutton AHA Ole_ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range and formats to new Workbook
Hi,
How do i modify this code below to copy 4 different sheets in same workbook to "C:\MyFolder\Newfile.xls" all with the same criteries. AHA. Ole "Tom Ogilvy" skrev i en meddelelse ... Private Sub CommandButton1_Click() Workbooks.Add Application.Activeworkbook.Worksheets(1).Name = "Other" With Application.ActiveWorkbook.Worksheets("Other") me.cells.copy Destination:=.Range("A1") .Range("34:65536").EntireRow.Delete .Range("V:IV").EntireColumn.Delete Application.DisplayAlerts = False .Parent.SaveAs "C:\MyFolder\Newfile.xls" Application.DisplayAlerts = True End With End Sub -- Regards, Tom Ogilvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
Copy Cells formats to another workbook | Excel Programming | |||
Copy worksheet values and formats into another workbook | Excel Programming | |||
Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |