abt the function "concatenate"

gospellers · August 2nd, 2004, 07:33 AM

I would like to combine two variables using the concatenate function
I've things like these:

Dim add1, add2
.
.
add1 = worksheets(sh).cells(i+1, 2)
add2 = worksheets(sh).cells(i+1, 3)
.
.
Range ("A8").select
activeCells.formulaR1C1= "=concatenate(add1, add2)"

The function does not recognize variables add1 and add2

BrianB · August 16th, 2004, 03:14 AM

If you really want to show the function in the cell :-

Code:

ActiveCell.Formula = _
"=concatenate(""" & add1 & """,""" & add2 & """)"

Better is (no Select needed):-

Code:

Range("A8").Value = add1 & add2

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.