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