Please help with Expected: end of statement error

[Ocean Zhang]

I'm trying to put the following code into a macro. It works when used as a regular formula in excel, but when I try to put it in VBA, I get an error. What am I doing wrong?

Please Login or Register  to view this content.

If it helps, I attached the actual file this macro will be used in. The existing macro works just fine. I just needed to add a snippet of code to the existing macro:

Please Login or Register  to view this content.

, but when I do that to the existing macro to make the above code, I get the error...

[jaslake]

Hi Ocean

Wrap the "d" with double quote marks

Please Login or Register  to view this content.