look here for ways
http://tinyurl.com/7fyl8

--
Don Guillett
SalesAid Software

"medicenpringles"
<medicenpringles.1r8zeb_1119812709.2956@excelfor um-nospam.com wrote in
message news:medicenpringles.1r8zeb_1119812709.2956@excelf orum-nospam.com...

is there any way to return the LETTER name of a column? the .Column
property returns the index, but is there a simple way of returning the
A, B, and so on value of column? this is what i would like to do:


Dim myRange as Range
Dim rowCopy as Integer
Dim colCopy as Integer
Dim colCopyLetter as String
Dim NewRange as String

Set rowCopy = myRange.Row
Set colCopy = myRange.Column
Set colCopyLetter = ???
Set NewRange = ColCopyLetter & rowCopy

'some code

Set myRange = (NewRange)


--
medicenpringles


------------------------------------------------------------------------
medicenpringles's Profile:
http://www.excelforum.com/member.php...o&userid=16458
View this thread: http://www.excelforum.com/showthread...hreadid=382337