bumbum2812
New Member
- Joined
- Sep 7, 2020
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hi Experts Please help me combine 2 var into 1 string with & in between.
My data is from A1:A2 & i have below code to put in MsgBox.
Any help will be so much apricated
My data is from A1:A2 & i have below code to put in MsgBox.
Rich (BB code):
Sub abc()
Dim lr3 As Long
Dim var As Variant
lr3 = Range("A" & Rows.Count).End(xlUp).Row
For Each var In Sheets("Sheet1").Range("A1:A" & lr3)
MsgBox var
Next var
End Sub
Any help will be so much apricated