Dim variable named after a string's content

**AstroZelda** · 05-11-2015, 04:22 AM

Hello !

Another weird question from me

It may look simple but I have no clue how to do it :

In my VBA code, I gave a string the value "part1" & "part2". What I want to do now is creating another string that will be called "part1part2", but if I write

Please Login or Register  to view this content.

it will not work, of course.

If anyone have an idea, I will be much grateful !

Thanks,

François

**Philb1** · 05-11-2015, 04:41 AM

As far as I know a variable can hold only the 1 value

**Kyle123** · 05-11-2015, 04:43 AM

No, you can't do that, why would you want to?

**AstroZelda** · 05-11-2015, 07:11 AM

Originally Posted by Kyle123

No, you can't do that, why would you want to?

I wanted that because I'll have to run a loop and Dim as many variables as the loop occurs...

**Kyle123** · 05-11-2015, 09:12 AM

Why can't you use an array?

**AstroZelda** · 05-11-2015, 09:22 AM

So I can write this, right ?

Please Login or Register  to view this content.

**Kyle123** · 05-11-2015, 10:05 AM

You'd want:

Please Login or Register  to view this content.

But yes

**AstroZelda** · 05-11-2015, 10:21 AM

Shouldn't I Dim the array at the begining too ?

Dim variable named after a string's content

LinkBack

Thread Tools

Rate This Thread

Display

Dim variable named after a string's content

Re: Dim varible named after a string's content

Re: Dim varible named after a string's content

Re: Dim varible named after a string's content

Re: Dim varible named after a string's content

Re: Dim varible named after a string's content

Re: Dim variable named after a string's content

Re: Dim variable named after a string's content

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] clear dynamic named range content

replace each content linked together to a named range

how to Read content or text of cells Named

create a Named Range via VBA based on cell content

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions