VBA End of Statement Error

**djl295** · 07-23-2015, 02:37 PM

VBA help

I am writing a Macro that adds rather large formulas to cells, I decided to save myself some time by first recording the outline of the macro with dumby forumlas () and then adding the real formulas into the code editor.

Here is the desired formula:

Formula:

Please Login or Register  to view this content.

Here is the desired macro:

Please Login or Register  to view this content.

Where dumby formula is "=IF(Banana=Bana,"""",Poop)".

Now, when I replace the dumby formula with the real formula above I get a compiler error that say 'end of statement' and the debugger highlights the "None" in the formula. Whats the deal and how can I fix it?

**SMITH.CRYSTAL** · 07-23-2015, 02:41 PM

Is it possible for you to upload a document that you are using the vba in so that I can take a look?

Thanks,
Crystal

**djl295** · 07-23-2015, 02:45 PM

The file is massive and mostly confidential but I will create an unloadable sample. Give me just a minute.

**djl295** · 07-23-2015, 02:49 PM

Here it is, the macro with the dumby text is "Testerrr" and the full formula is in J4.

Thanks so much. Help Request.xlsm

**cyiangou** · 07-23-2015, 02:53 PM

I haven't looked at your file yet, but I'm working on the assumption that you just need to duplicate all quotation marks in the formula as required by the vb editor.

Please Login or Register  to view this content.

**djl295** · 07-23-2015, 02:59 PM

This helped but now I am getting a different error: "Application-defined or object-defined error". and the debugger is highlighting the following:

Please Login or Register  to view this content.

**cyiangou** · 07-23-2015, 03:10 PM

You need to use Formula not FormulaR1C1

formula_entry.xlsm (makes #N/A s because there is no data)

Please Login or Register  to view this content.

**djl295** · 07-23-2015, 03:24 PM

Thank you so much. One final thing.

I tried repeating the same code on another formula in the same macro and am running into the same problem:

Please Login or Register  to view this content.

**Norie** · 07-23-2015, 03:27 PM

Too many closing parenthesis.

Please Login or Register  to view this content.

VBA End of Statement Error

LinkBack

Thread Tools

Rate This Thread

Display

VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Re: VBA End of Statement Error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting #value! Error with =min(if statement

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

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

[SOLVED] Runtime Error - Subscript out of range despite On Error statement

Path/File access error (Error 75) using Name Statement

[SOLVED] Path/File access error (Error 75) after using Name Statement

Bookmarks

Bookmarks

Posting Permissions