code_junkie

Write a formula in an Excel Cell using VBA

Nov 12th, 2011
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. Sub Jours_ouvres()
  2. Dim Feuille_Document As String
  3. Feuille_Document = "DOCUMENT"
  4.  
  5. Application.Worksheets(Feuille_Document).Range("F2").Formula = "=SUM(D2;E2)"
  6.  
  7.  
  8. End Sub
  9.  
  10. (...)Formula = "=SUM(D2,E2)"
Add Comment
Please, Sign In to add comment