Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 729
  • Last Modified:

Enter a formula string in Excel VBA (division)

Dear Experts:

I need to enter a formula into K71 as a string. The formula is as follows:

Range("J71") / Range("$B$6").

I got no idea how this works in Excel VBA.

Could somebody please help me with this?

Thank you very much in advance.

Regards, Andreas


strFormula = formula string?

ActiveWorkbook.Sheets("Evaluation").Range("K71").Formula = strFormula
0
AndreasHermle
Asked:
AndreasHermle
2 Solutions
 
MacroShadowCommented:
Range("K71").Formula = "=J71/$B$6" 

Open in new window

0
 
Rgonzo1971Commented:
Hi,

pls try

strFormula = "=J71/$B$6"
ActiveWorkbook.Sheets("Evaluation").Range("K71").Formula = strFormula

Open in new window

Regards
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now