MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Get current column letter


Posted by Melanie Swarner on October 23, 2001 7:59 AM

How do I capture the current column letter? The column property returns the number of the column, but I'm trying to create a range like this:

MyRange = Range(ActiveCell.Columns & "3")

So if I was in D65 MyRange would be set to "D3"

Is there a way to do this? Thanks!


Posted by Juan Pablo on October 23, 2001 8:01 AM

I'd suggest using...

MyRange =Cells(3,ActiveCell.Column)

Juan Pablo

Posted by Melanie Swarner on October 23, 2001 9:15 AM

Thanks! (nt)