预期的简单公式插入语句错误结束 [英] Expected end of Statement Error on Simple Formula Insert

问题描述

###。value == LOOKUP（LEFT（W2），{C，A，B}，{拾取，收集 }）

我想让VBA做这个简单的公式，但是得到预期：结束语句错误。
似乎我需要定义一些东西，因为VBA不能识别字符{}括号。

I want VBA to do this simple formula but getting "Expected: end of Statement" error. It seems that I need to define something as VBA doesn't recognize character "{}" the brackets.

推荐答案

可能要求您结束这样的脚本

It might be requiring you to end the script like this

###.value = "=LOOKUP(LEFT(W2),{"C","A","B"},{"Pick Up","Collect","Prepaid"});"

OR

###.value = "=LOOKUP(LEFT(W2),{"C","A","B"},{"Pick Up","Collect","Prepaid"})";

注意 结尾的分号> ';' 即可。

NOTICE: the Semi-colon at the end ';'.

我不是很久以前的VBA用户。但只是尝试。删除这个答案，如果它不够好。

I'm not a VBA user for a long time. but just try. Delete this answer if its not good enough.

这篇关于预期的简单公式插入语句错误结束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！