Results 1 to 11 of 11

how to extract column letter of a cell & select cell by referencing its column number

Threaded View

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Smile how to extract column letter of a cell & select cell by referencing its column number

    If I have a named cell in the worksheet, "myCell", how can I extract it's column letter using VB?

    Also, in addition to the above, if I have a column number (not letter) and a row number of a cell, how can I use that info to select that cell in my worksheet? So for example, I want to be able to select cell C5, (and all my sub knows is the cell's row, which is 5, and column number which is 3).

    Thank you.
    Last edited by luv2glyd; 07-12-2010 at 08:58 AM.
    You either quit or become really good at it. There are no other choices.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1