copy formula using VB code

  • Thread starter Thread starter Guest
  • Start date Start date
Would something like the following work?

Sub CopyFormula()
Dim Frm As String
Frm = ActiveCell.Formula
Worksheets.Add
Range("A1").Formula = Frm
End Sub

You no doubt would want to add more code but this may get you started.

HTH,

TK
 
Thanks very much. Unfortunately I have changed the form slightly.
What I could do with now is a code that would copy and paste the formula,
say in cell "H11", and paste it in the next cell "H12". and when cell "H12"
is filled with a value, the formula is pasted to the next cell("H13"), and so
on.
I hope it's clear.
Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy formula when creating new sheet 3
Copy data based on month? 2
copy and paste formula using vb code 4
Auto Fill Format or Copying Formulas 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
I can't copy and paste equations 0
copy and paste using vb code 1
Copy of VB code to new spreadsheet 6

Back
Top