| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy active worksheet to new workbook
Hi,
I want to create a macro that will allow me to use a shortcut that will: (1) copy the values & the format (i.e. not the formulas) of the active worksheet to a new workbook; and (2) save that new workbook as "Claim" in a specified file location. Hope someone can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
| I want to copy the active workbook name to a cell... | Excel Discussion (Misc queries) | |||
| Macro: Exit active workbook without save? | Excel Worksheet Functions | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Threaded Mode
