VBA to enter a formula, Compile Error

[Speshul]

I'm trying to enter a formula using a macro, and normally this works just fine, but for some reason excel hates me today. I know it has something to do with a quote missing or extra somewhere along the line, but there are a lot of quotes. I could use a second set of eyes!

Please Login or Register  to view this content.

The purpose of the macro is to generate a ton of SQL Queries for me. So it will convert:

This is a "string", of text-with stuff's
Into
INSERT INTO Table1 VALUES('THISISASTRINGOFTEXTWITHSTUFFS')

Thanks.

[Norie]

Which characters are you trying to remove?

[Speshul]

These:

[SPACE].-_/&^%[]:;#@$|(),'"

Char Codes:
32
34
35
36
37
38
39
40
41
44
45
46
47
58
59
64
91
93
94
95
124

[JosephP]

maybe

Please Login or Register  to view this content.

[Speshul]

Perfect thanks.

[Norie]

Have you considered using CHAR()?

Please Login or Register  to view this content.