How to convert column number to letter

**iturnrocks** · 11-20-2007, 07:46 PM

I need to select a range of cells based on a column number.

Please Login or Register  to view this content.

Thank you

**jindon** · 11-20-2007, 08:11 PM

1)

Please Login or Register  to view this content.

2)

Please Login or Register  to view this content.

You don't need to "Select" the range most of the time, anyway.

**jindon** · 11-20-2007, 08:53 PM

Originally Posted by iturnrocks

What Im trying to do is Select a larger range of cells like

mycol = 5
myrow = 5

Range(mycol & myrow:mycol & myrow + 50).Select

Does this make any sense?

Please Login or Register  to view this content.

**mudraker** · 11-21-2007, 03:44 AM

iturnrocks

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

**iturnrocks** · 11-21-2007, 09:51 AM

If that "code" was actual code I would have wrapped it. That was only me trying to explain what I wanted to do. But I will go back and wrap it anyway.

How to convert column number to letter

LinkBack

Thread Tools

Rate This Thread

Display

How to convert column number to letter

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions