| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula when creating new sheet
using something like this:
Workbooks("newbook.xls").Worksheets("sheet1").Rang e("a1").Formula = Workbooks("oldbook.xls").Worksheets("sheet1").Rang e("a1").Formula -- Allllen "ASU" wrote: How can I copy and paste formulas, using vb codes, when creating a new spreadsheet. -- ASU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| Copy Formula That References Another Sheet | Excel Discussion (Misc queries) | |||
| Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
| how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Threaded Mode
