| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Column Width Language
This does not work:
Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy ThisWorkbook.Sheets(ShName).Range("A1").PasteSpeci al xlColumnWidths But this does: Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy ThisWorkbook.Sheets(ShName).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False is the command in the first code excerpt not xlColumnWidths? thanks... Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Set Column Width Based On Total Width Of Other Columns | Excel Programming | |||
| copy paste (column width prb) | Excel Programming | |||
Threaded Mode
