Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate Text in Visual Basic
Hello there,
I need to aggregate two text as "EUR" and "GBP" to create a third text as "EURGBP". Here is the code I am using now. CurrencyCode = "Currency1Currency2" in Locals window, in place of "EURGBP". Any ideas? Kind regards to everybody, Daniel Sub Convert_Figures() Dim Currency1 As Variant Dim Currency2 As Variant Dim CurrencyCode As Variant For i = 2 To Last_Row(Sheets("Stocks").Columns("A:A")) + 1 Currency1 = Sheets("Characteristics").Range("G" & i) Currency2 = Sheets("Characteristics").Range("H" & i) CurrencyCode = "Currency1" & "Currency2" Next i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Text in Visual Basic | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Text manipulation with Visual Basic | Excel Programming | |||
Visual Basic Text Functions | Excel Programming | |||
Converting text to pdf file using Visual Basic | Excel Programming |