Refer dynamically to the column argument in a range statement

[Glory]

I need a way to refer dynamically to the column argument in a range statement.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
This isn’t working:
<o> </o>

e = 1
<o:p> </o:p>
Range(Cells(1, e).Columns & “2”).

<o> </o>
The desired result is “Range(“A2”)”, except the column will change to become “B” and “C” as the code loops.
<o> </o>
Any ideas?

 

[Glory]

In other words, I’m trying to convert a column number to a column letter.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Any help will be appreciated.

 

[Glory]

Bump.

 

[mirabeau]

In other words, I’m trying to convert a column number to a column letter.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Any help will be appreciated.

Try

MsgBox Split(Columns(2).Address(, 0), ":")(0)

 

[tusharm]

Use

Cells(2,e)

I need a way to refer dynamically to the column argument in a range statement.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
This isn’t working:
<o> </o>

e = 1
<o:p> </o:p>
Range(Cells(1, e).Columns & “2”).

<o> </o>
The desired result is “Range(“A2”)”, except the column will change to become “B” and “C” as the code loops.
<o> </o>
Any ideas?

 

[Glory]

I was looking for a way to refer to the column name in the range method because I need to “Copy” a series of ranges.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
eg “Range(DynamicColumn & DynamicRow “:”DynamicColumn & DynamicRow”)
<o> </o>
Is there a way to use the Cells property to refer to a range of cells?

 

[tusharm]

Range(Cells(),Cells())

You can also find this from Excel VBA help -- well, at least you could. I don't know if the newer versions of help provide that information.

I was looking for a way to refer to the column name in the range method because I need to “Copy” a series of ranges.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
eg “Range(DynamicColumn & DynamicRow “:”DynamicColumn & DynamicRow”)
<o> </o>
Is there a way to use the Cells property to refer to a range of cells?

 

[mirabeau]

In other words, I’m trying to convert a column number to a column letter.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Any help will be appreciated.

Obviously not!