Concatenate two variables (String & Integer)

[Guest]

Hi,

How to use the variable in the following.

Range("A1").Select

Thanks & Regards,

D.V.Sreenivas

 

[Guest]

Sreenivas:

try,

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

 

[Guest]

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.

 

[keepITcool]

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 :