Hi

Good day!

I'm a newbie to VBA

I tried running your code - but did not see any output

just wanted to understand what I was doing wrong

Did you see any error messages??

no

i ran the code using F5 - no output

I tried using step F8

nothing... yet... I don't know how it is failing

There are many things to check. Make sure the source data in in cols A and B

yes it is

Make sure the worksheet with the data is Selected

Oops

tried Selection as well - doesn't work

wait

I think i need to save the workbook with some name to make this work?

even saving the workbook with .xlsm extension did not help

Make sure your Security Settings allow macro execution.

they do

"Enable all macros" is selected

does this code work for you?

i mean on your computer?

The code works on my computer....try to insert some MsgBox statements to see where the code is failing.

ok

It is not going through the "For" loop to populate the values in the adjacent cells

LBound(ary) = 0 and UBound(ary) = -1

i have never understood these functions

Found it

We are making great progress!! It means that the Split() function is failing. In this case we are trying to split the items in column B using the two-character separator comma space

The second column was not present - instead all the text was in first column as text

sorry to have bothered you Gary

It is no bother..............unless we help each other, progress can be difficult.

I'm a big fan of yours!

Appreciate all your contribution

Thank you for the feedback!

I am leaving chat