Excel Macros - Too many line continuations

Posted by pojomx on Stack Overflow See other posts from Stack Overflow or by pojomx
Published on 2010-05-10T20:19:02Z Indexed on 2010/05/10 20:24 UTC
Read the original article Hit count: 324

Filed under:
|

Hi, I have a "large" sql query (like 200 lines)...

dim query as string
query = "..................................." & _
        "..................................." & _
           .... Like a lot lines later...
        "..................................."

function query,"sheet 1"

When i do this, excel says "Too many line continuations."

What is the best way, to avoid this?

Thanks for your help.

© Stack Overflow or respective owner

Related posts about excel

Related posts about macro