| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy worksheet and paste it in New workbook, all data except Formulas
Hi,
I want to copy the entire worksheet and paste it into new worksheet in new workbook. I want to copy everything except formulas. I am able to do it though Paste special , values, format , comments everythings goes very well to new worksheet except the Images. I have some images in some cells in my workbook. How to copy and paste images too..though VBA programming. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet and paste it in New workbook, all data except Formulas
Sudarshan,
This copies Sheet1 from Book1 to Book2, adding the new sheet at the beginning. It copies the whole sheet including images. The second line converts all formulas in the UsedRange of the copied sheet to values: Workbooks("Book1").Sheets("Sheet1").Copy Befo=Workbooks("Book2").Sheets(1) ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value hth, Doug Glancy "Sudarshan" wrote in message ... Hi, I want to copy the entire worksheet and paste it into new worksheet in new workbook. I want to copy everything except formulas. I am able to do it though Paste special , values, format , comments everythings goes very well to new worksheet except the Images. I have some images in some cells in my workbook. How to copy and paste images too..though VBA programming. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet and paste it in New workbook, all data except Formulas
-----Original Message----- Sudarshan, This copies Sheet1 from Book1 to Book2, adding the new sheet at the beginning. It copies the whole sheet including images. The second line converts all formulas in the UsedRange of the copied sheet to values: Workbooks("Book1").Sheets("Sheet1").Copy Befo=Workbooks("Book2").Sheets(1) ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value hth, Doug Glancy "Sudarshan" wrote in message ... Hi, I want to copy the entire worksheet and paste it into new worksheet in new workbook. I want to copy everything except formulas. I am able to do it though Paste special , values, format , comments everythings goes very well to new worksheet except the Images. I have some images in some cells in my workbook. How to copy and paste images too..though VBA programming. Thanks in advance. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet and paste it in New workbook, all data except Formulas
Hi,
Thanks for quick reply..It works fine..But I have one problem.. The sheets which I am Copying has VBA code behind it.. I don't want the code to be copied new worksheet.. Any solutions for it.. Thanks, Sudarshan -----Original Message----- Sudarshan, This copies Sheet1 from Book1 to Book2, adding the new sheet at the beginning. It copies the whole sheet including images. The second line converts all formulas in the UsedRange of the copied sheet to values: Workbooks("Book1").Sheets("Sheet1").Copy Befo=Workbooks("Book2").Sheets(1) ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value hth, Doug Glancy "Sudarshan" wrote in message ... Hi, I want to copy the entire worksheet and paste it into new worksheet in new workbook. I want to copy everything except formulas. I am able to do it though Paste special , values, format , comments everythings goes very well to new worksheet except the Images. I have some images in some cells in my workbook. How to copy and paste images too..though VBA programming. Thanks in advance. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet and paste it in New workbook, all data except Formulas
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany Sudarshan wrote: Hi, Thanks for quick reply..It works fine..But I have one problem.. The sheets which I am Copying has VBA code behind it.. I don't want the code to be copied new worksheet.. Any solutions for it.. Thanks, Sudarshan -----Original Message----- Sudarshan, This copies Sheet1 from Book1 to Book2, adding the new sheet at the beginning. It copies the whole sheet including images. The second line converts all formulas in the UsedRange of the copied sheet to values: Workbooks("Book1").Sheets("Sheet1").Copy Befo=Workbooks("Book2").Sheets(1) ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value hth, Doug Glancy "Sudarshan" wrote in message ... Hi, I want to copy the entire worksheet and paste it into new worksheet in new workbook. I want to copy everything except formulas. I am able to do it though Paste special , values, format , comments everythings goes very well to new worksheet except the Images. I have some images in some cells in my workbook. How to copy and paste images too..though VBA programming. Thanks in advance. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data and formulas from a column and paste into a row | Excel Worksheet Functions | |||
| Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
| how do I copy a worksheet with formulas to another workbook? | Excel Worksheet Functions | |||
| How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
| How to copy worksheet or workbook without formulas | Excel Discussion (Misc queries) | |||
Linear Mode
