Hi,

I have a unique identifier in the format:

ABC-R-<number

Where only <number changes .

As part of a search capability, the user is able to enter the specific value
of <number that they are looking for - this is in an adjacet cell to the
ABC-R- text.

What I want to do is concatenate ABC-R- and the user-defined <number then
pass it to a String which I can then use to search the data arrays. What is
the format for this, or can't I do it?

If not, any suggestions on how I can pass a user-defined value to a variable?

TIA

Dave

Maybe

mystring = Range("A1").Value & Range("B1").Value

Mike

"Risky Dave" wrote:

Hi,

I have a unique identifier in the format:

ABC-R-<number

Where only <number changes .

As part of a search capability, the user is able to enter the specific value
of <number that they are looking for - this is in an adjacet cell to the
ABC-R- text.

What I want to do is concatenate ABC-R- and the user-defined <number then
pass it to a String which I can then use to search the data arrays. What is
the format for this, or can't I do it?

If not, any suggestions on how I can pass a user-defined value to a variable?

TIA

Dave

I've worked it out, thankx

"Risky Dave" wrote:

Hi,

I have a unique identifier in the format:

ABC-R-<number

Where only <number changes .

As part of a search capability, the user is able to enter the specific value
of <number that they are looking for - this is in an adjacet cell to the
ABC-R- text.

What I want to do is concatenate ABC-R- and the user-defined <number then
pass it to a String which I can then use to search the data arrays. What is
the format for this, or can't I do it?

If not, any suggestions on how I can pass a user-defined value to a variable?

TIA

Dave