| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate two variables (String & Integer)
Hi,
How to use the variable in the following. Range("A1").Select Thanks & Regards, D.V.Sreenivas |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate in a string | Excel Worksheet Functions | |||
| ListBox2.AddItem ListBox1.Value becomes a String when being Integer? | Excel Programming | |||
| Declaring variables (Long, String, Integer) and interpretation spe | Excel Programming | |||
| Is there a function to convert a string representing an integer i. | Excel Programming | |||
| how do you concatenate two variables in VBA | Excel Programming | |||
Hybrid Mode
