Results 1 to 5 of 5

Simple cell addressing issue searched long time

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2009
    Location
    Rockville, Maryland, USA
    MS-Off Ver
    Office 2007
    Posts
    9

    Simple cell addressing issue searched long time

    I need to ask user to input the row ("rowin") and column ("colin") address in order to activate a cell. The mose natural inputs from the user will be an integer for row and one or two alphbats for column. Say, for example, the user input (82, AY), how do I represent the cell in code? I know I want to say something like Range("AY82"). But I just could not figure out how to concatenate "colin" & "rowin" to make it AY82 to Excel.

    I am new and spend quite a while to try to find an existing Q&A without a luck. If this is a dumb question, I appologize for wasting your time. But still would appreciate an answer.
    Last edited by Nelson Li; 03-17-2009 at 11:01 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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