9!GR@BzyQ37b
05-01-2020, 03:03 AM
Hi,
I hope someone can help me with this vba question.
I want to concatenate some values, but these values are variable. Sometimes the're 3 values and sometimes the're 5 or more values.
In cell A4 is a value and behind that the're 3 values and those 3 values I need to concatenate.
The next cell is A7 and behind that the're 5 values and those 5 values I need to concatenate.
I tried to count the empty cells between the values in column A and use this as variant for the concatenate formule. But it didn't worked.
I've attached a example so you maybe understand my question. 26525
Thanks,
Peter
I hope someone can help me with this vba question.
I want to concatenate some values, but these values are variable. Sometimes the're 3 values and sometimes the're 5 or more values.
In cell A4 is a value and behind that the're 3 values and those 3 values I need to concatenate.
The next cell is A7 and behind that the're 5 values and those 5 values I need to concatenate.
I tried to count the empty cells between the values in column A and use this as variant for the concatenate formule. But it didn't worked.
I've attached a example so you maybe understand my question. 26525
Thanks,
Peter