通过MACRO EXCEL VBA运行公式 [英] EXCEL VBA run formula via MACRO

问题描述

我之前已经问过这样的问题，但是我对VBA公式真的很不好.

I had already asked a question like this before but I'm really bad at VBA formula.

这是我的公式:

Worksheets("Sheet1").Range(CellRange).formula = "=IF(Sheet2!E$4=X;CONCATENATE(Sheet3! """ & myString """, Not defined)"

运行时错误1004:由应用程序或对象定义的错误

Run-time error 1004: error defined by the application or object

myString是 STRING ，其中包含单元格的地址.

myString is a STRING and contains the address of a cell.

我以前一直按照上一个问题的解释进行操作一个带有好的答案

I've used to follow the explanation from my previous question A question with a really good answer

但是这次没有用.有什么建议吗?

But It didn't worked this time. Any suggestions?

谢谢！

推荐答案

Worksheets("Sheet1").Range(cellrange).Formula = _
  "=IF(Sheet2!E$4=""X"",Sheet3!" & myString & ", ""Not defined"")"

这篇关于通过MACRO EXCEL VBA运行公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！