Excel VBA String Concat Problem

**javajoemorgan** · 06-08-2009, 11:26 AM

I am trying to concatenate a string together for a formula within an excel macro. This is the line of code:

Please Login or Register  to view this content.

Where "dataRow" and "numRecsCol" are Integers. This is the result:

Please Login or Register  to view this content.

How do I keep it from adding the stupid single quotes that I have absolutely nowhere in my code, most especially in the places where it has inserted them? The quotes totally screw up the formula so it doesn't work. If, after running the macro, I go to a row and take the quotes from the formula, it works just as it should.

**starryknight64** · 06-08-2009, 11:33 AM

Try this instead:

Please Login or Register  to view this content.

Right off the bat, it seems a little slow to me, but it does get rid of those pesky single quotes.

I know I've seen this topic before though in this forum. I can't remember if this was the solution or not though. I'll poke around and see what I can find. In the meantime, see if that works for you.

**javajoemorgan** · 06-08-2009, 01:30 PM

Nope... that worked... don't care if it is slow.... just care that it works...

**shg** · 06-08-2009, 01:51 PM

Or ...

Please Login or Register  to view this content.

Excel VBA String Concat Problem

LinkBack

Thread Tools

Rate This Thread

Display

Excel VBA String Concat Problem

Re: Excel VBA String Concat Problem

Re: Excel VBA String Concat Problem

Re: Excel VBA String Concat Problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions