Simple cell addressing issue searched long time

**Nelson Li** · 03-16-2009, 06:15 PM

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.

**shg** · 03-16-2009, 06:42 PM

Please Login or Register  to view this content.

refers to the cell.

**dustycrockett** · 03-16-2009, 06:56 PM

This is also perfectly acceptable:

Please Login or Register  to view this content.

**nomel** · 03-16-2009, 07:14 PM

Why not have the user click the cell they want?

**Nelson Li** · 03-17-2009, 11:00 AM

Thank you guys. All suggestions work fine. The reason not to have the user select the cell manually is because there are steps between selecting the cell and actually doing something relative to the cell. The cell will not be active at the action time.