| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Past with macro
Hello all,
I copy a Range and then paste it into new excel workbook. Duiring this action I use the below code. I can pastespecial the column widths but cant paste the Row Height. Is there any possibility that I can copy the RowHeights too?? Sheets(1).Range("A1").PasteSpecial Paste:=xlValues Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteFormats Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteColumnWidths Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteRowHeight ????????? -- thanx Murat Demir HEKİMOĞLU have a nice day! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Copy/Paste Data into one wksht, skipp one row before past | Excel Discussion (Misc queries) | |||
| Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) | |||
| Copy and Past | Excel Discussion (Misc queries) | |||
| copy & past in same format | Excel Discussion (Misc queries) | |||
| Macro to copy and past selected rows only... | Excel Programming | |||
Threaded Mode
