Concatenate

Question

Hi Everyone,

Greetings !!!

Hope Everyone is Safe With Your Family.

I Have A Problem A Coding Problem In VBA

I have in
Column A - Account Number
Column B - Company Code

Now I want to concatenate both (A&B) in Column E untill my last row of (A&B).

Because day by day the total rows of A&B will be more

I'm getting errors as overflow / stock overflow like that.

Will You please help me on this, would be great !!!

Answer 1

I used to do it with dynamic range.
u should treat col A like that and process each item of that range.
it might be a bit difficult the first time but I applied it very often although many years ago.

here I found a simple example ... doesn't fit completely
but u can loop from 0 to lr and edit col E.

Dim lr as long

lr=range("A" & rows.count).end(xlup).row
Range("B2:B" & lr).value=123

End Sub