Concatenate two variables (String & Integer)

Hi,

How to use the variable in the following.

Range("A1").Select

Thanks & Regards,

D.V.Sreenivas

Sreenivas:

try,

Set rng = Range("A1")
rng.Select

--
天行健，君�*�以自強不息
地勢坤，君�*�以厚德載物

http://www.vba.com.tw/plog/


"Sreenivas Varadhan" wrote:

> Hi,
>
> How to use the variable in the following.
>
> Range("A1").Select
>
> Thanks & Regards,
>
> D.V.Sreenivas

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.
--
- K Dales


"Sreenivas Varadhan" wrote:

> Hi,
>
> How to use the variable in the following.
>
> Range("A1").Select
>
> Thanks & Regards,
>
> D.V.Sreenivas

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.