| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste a sheet to new workbook
Dear all
i do not have to many knoweldeges for vb. what i am looking for is that: I have a workbook with many sheets where i fill on specific sheet with to many formulas (Sheet 1). There is any way to have a macro where to copy this sheet exactly as it is, into a new workbook, but without the formulas? (copy paste values and formats). Thanks in advance Manos |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Paste a sheet to new workbook
Hi Manos
Try this: ' Copy active sheet in a new workbook ActiveSheet.Copy ' Select the complete sheet and copy it Cells.Select Selection.Copy ' Paste the complete sheet as values Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Regards reklamo "Manos" wrote: Dear all i do not have to many knoweldeges for vb. what i am looking for is that: I have a workbook with many sheets where i fill on specific sheet with to many formulas (Sheet 1). There is any way to have a macro where to copy this sheet exactly as it is, into a new workbook, but without the formulas? (copy paste values and formats). Thanks in advance Manos |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Paste a sheet to new workbook
Thank you very much
"reklamo" wrote: Hi Manos Try this: ' Copy active sheet in a new workbook ActiveSheet.Copy ' Select the complete sheet and copy it Cells.Select Selection.Copy ' Paste the complete sheet as values Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Regards reklamo "Manos" wrote: Dear all i do not have to many knoweldeges for vb. what i am looking for is that: I have a workbook with many sheets where i fill on specific sheet with to many formulas (Sheet 1). There is any way to have a macro where to copy this sheet exactly as it is, into a new workbook, but without the formulas? (copy paste values and formats). Thanks in advance Manos |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to enable Copy and Paste when the sheet and workbook is protected | Excel Discussion (Misc queries) | |||
| how to copy a sheet to diferent workbook. no paste | Excel Programming | |||
| Copy and paste data from one sheet to another in a single workbook | Excel Programming | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| automatic copy and paste from sheet to sheet in a workbook | Excel Programming | |||
Linear Mode
