Renaming Values in a selected range.

[jcook1]

Hi there, i'm a bit of a beginner and am having issues with the language.

I'm trying to make it so i can refer to the values in a selected range.

eg

Dim XValues As String

Range(Selection, Selection.End(xlDown)).Select

Xvalues = <The Values in the range>

Any ideas?

 

[Techtnologies]

Can you tell us a little more? With the code example it is hard to tell what you are trying to accomplish.

Where are you pulling these values from, etc?

Thanks

Chad
Techtnologies LLC

http://www.techtnologies.com

 

[SkipVought]

Hi,

This looks like VBA. Are you doing this in Excel?

If so, please post in VBA Visual Basic for Applications (Microsoft) forum707

Skip,
[sub]
[red][/red]
[/sub]

 

[JoeAtWork]

I'm rusty on Excel VBA but I believe your XValues would be a Range object. Something like:

Dim XValues As Range

Set XValues = Range("a1", "g200")