Thread: copy formula when creating new sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
  
Posts: 341
Default 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
Reply With QuoteReply With Quote