| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining Column Widths When Copying
I have a macro, which copies the worksheets from a master workbook to a new
workbook. However, while the page setup copies over just fine, the column widths do not. I want the column widths to remain the same regardless of what I copy to the worksheets. Please help!! Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maintaining Column Widths When Copying
Copy the worksheet not just the cells.
Application.ActiveSheet.Copy _ Befo=Workbooks(myFirstWorkbook).Sheets(1) -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Lilbit" wrote: I have a macro, which copies the worksheets from a master workbook to a new workbook. However, while the page setup copies over just fine, the column widths do not. I want the column widths to remain the same regardless of what I copy to the worksheets. Please help!! Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| copying Excel column names and widths to a blank spreadsheet | Excel Discussion (Misc queries) | |||
| Maintaining column formatting when copying a row to another sheet based on a value | Excel Programming | |||
| copying range column widths | Excel Programming | |||
| Maintaining Column Widths in CSV Format File | Excel Programming | |||
Linear Mode
