Excel VBA - Range.FormulaR1C1 "XXXXX" Compile Error: Expected: end of statement

**77highland** · 08-20-2019, 09:26 AM

Hi All,

I am looking to automatically populate a cell with a formula.....

When trying to use the below I am presented with Compile error: Expected: end of statement, due to the highlighted below........

With Range("C4")
.FormulaR1C1 = "=IF('KARDEX DATA'!C2="","0",'KARDEX DATA'!C2)"

**rorya** · 08-20-2019, 09:30 AM

You need to double-up any quotes that are part of the formula

Please Login or Register  to view this content.

**KOKOSEK** · 08-20-2019, 09:31 AM

Hi

Try

Formula:

Please Login or Register  to view this content.

if you want to display 0 (zero as value).

P.S. @77highland - please use CODE tag to marked any code in post.

Excel VBA - Range.FormulaR1C1 "XXXXX" Compile Error: Expected: end of statement

LinkBack

Thread Tools

Rate This Thread

Display

Excel VBA - Range.FormulaR1C1 "XXXXX" Compile Error: Expected: end of statement

Re: Excel VBA - Range.FormulaR1C1 "XXXXX" Compile Error: Expected: end of statement

Re: Excel VBA - Range.FormulaR1C1 "XXXXX" Compile Error: Expected: end of statement

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help with "Compile Error: Expected: Expression"

[SOLVED] Shell Function "Compile Error: Expected procedure, not variable"

[SOLVED] Compile Error - "Expected array "- when declaring a string variable??

Why is this code gives "Compile error Expected: list seperator or)"

[SOLVED] Problem with "Compile error: Expected Fuction or variable"

GoTo compile error: "Expected: line number or label"

Mac issue (please help) "Compile error: Expected Function or variable"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions