Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Mystery
Hello
I want to create a new workbook using 3 worksheets,(these worksheets have formulas, I know how to do this part my problem is that I only want the values on the new workbbook. If I include in the macro copy and paste special values will my formulas on the orginal workbook be deleted. ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Mystery
Only if you then save the file with the same name. If you use File |
Save As then you can save the file with a different name, and the original workbook will be untouched. Hope this helps. Pete On Feb 26, 7:42 pm, Wanna Learn wrote: Hello I want to create a new workbook using 3 worksheets,(these worksheets have formulas, I know how to do this part my problem is that I only want the values on the new workbbook. If I include in the macro copy and paste special values will my formulas on the orginal workbook be deleted. ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Mystery
Only if you then save the file with the same name. If you use File |
Save As then you can save the file with a different name, and the original workbook will be untouched. Hope this helps. Pete On Feb 26, 7:42 pm, Wanna Learn wrote: Hello I want to create a new workbook using 3 worksheets,(these worksheets have formulas, I know how to do this part my problem is that I only want the values on the new workbbook. If I include in the macro copy and paste special values will my formulas on the orginal workbook be deleted. ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mystery Value in my Spreadsheet! | Excel Discussion (Misc queries) | |||
MYSTERY!! | Excel Discussion (Misc queries) | |||
Mystery Cell | Excel Discussion (Misc queries) | |||
VLOOKUP Mystery | Excel Worksheet Functions | |||
HELP!! Unsolved Mystery | Excel Discussion (Misc queries) |