Benzadeus
08-01-2009, 10:52 AM
I'm having an issue with these codes:
Sub Test1()
'***
'Values of cells A1 = "Hi" and B1 = "Lo"
'***
Debug.Print Join(Range("A1:B1"), ", ") 'I want 'Hi, Lo' as output.
End Sub
and this:
Sub Test2()
'***
'Values of cells A1 = "Hi" and B1 = "Lo"
'***
Dim var 'What type is this variable?
Set var = Range("A1:B1")
Debug.Print Join(var, ", ") 'I want 'Hi, Lo' as output.
End Sub
How do I make them work?
Sub Test1()
'***
'Values of cells A1 = "Hi" and B1 = "Lo"
'***
Debug.Print Join(Range("A1:B1"), ", ") 'I want 'Hi, Lo' as output.
End Sub
and this:
Sub Test2()
'***
'Values of cells A1 = "Hi" and B1 = "Lo"
'***
Dim var 'What type is this variable?
Set var = Range("A1:B1")
Debug.Print Join(var, ", ") 'I want 'Hi, Lo' as output.
End Sub
How do I make them work?