Concatenate two variables (String & Integer)
 

Hi,

How to use the variable in the following.

Range("A1").Select

Thanks & Regards,

D.V.Sreenivas

Concatenate two variables (String & Integer)
 

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

Concatenate two variables (String & Integer)
 

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

Concatenate two variables (String & Integer)
 

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.