Compile error: Expected error: End of statement

**chubbster31** · 07-14-2016, 07:52 AM

Range("B1").Formula = "=(""TPR""&" "&TEXT(profitloss!B3,"mmmm")&" "&YEAR(profitloss!B3))"

This is the code I am trying to run. I know i have to use double apostrophes in places but I am unsure where and I can't seem to get it to work.

Thanks

**BadlySpelledBuoy** · 07-14-2016, 07:58 AM

Formula:

Please Login or Register  to view this content.

BSB

**xlnitwit** · 07-14-2016, 07:58 AM

Hi,

Any quotation marks within the formula string must be doubled. The formula can also be simplified as you are formatting a date. Therefore the code could become

Please Login or Register  to view this content.

**chubbster31** · 07-14-2016, 09:25 AM

thanks you both

Compile error: Expected error: End of statement

LinkBack

Thread Tools

Rate This Thread

Display

Compile error: Expected error: End of statement

Re: Compile error: Expected error: End of statement

Re: Compile error: Expected error: End of statement

Re: Compile error: Expected error: End of statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Compile error: Expected end of statement

[SOLVED] Compile Error: Expected: End of Statement

[SOLVED] Compile error: Expected end of statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

compile error, Expected: end of statement

Compile Error Expected: End of statement

How to fix a Compile Error Expected: End of statement.

Bookmarks

Bookmarks

Posting Permissions