Arghhh...this is asking for trouble...

the RowNo should be defined as a Long
else the code will misbehave above row 32768



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


K Dales wrote :

Do you mean you have a string variable that represents the column
("A") and an integer variable that represents the row (1)? It would
be like this:

Dim ColLtr as String, RowNo as Integer
ColLtr = "A"
RowNo = 1
Range(ColLtr & RowNo).Select

VBA can do the conversion from integer to string when you concatenate
with &. However, in other circumstances you may need to convert to
string first with CStr and make sure it is formatted properly.