| Home |
| Search |
| Today's Posts |
|
#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_ |
| 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 | |||
Threaded Mode
