Not getting correct output problem

Hi friends,
I want to concatenate the 3 different columns in column 'g, ac and ad' respectively. I'm not getting the correct output in column 'g' and the concatenate output of column 'ac and ad' respectively. The output of concatenate 'ac and ad' displays in a single column 'g' and the concatenate output of column 'g' is not displaying in column 'g'.

Please see the following code and suggest me the correction to get correct output.

Please Login or Register  to view this content.

Thanking you in anticipation.

Regards,

Mukesh

Hi, Mukesh,

you should take up the tips you get: you only need to check for the row number once.

You could step through the code all by yourself by setting Stop intoc the code near the beginning or add a break by pressing F9 and see what the code is doing - if you want to concatenate the contents of several cells into one cell which holds contents you should not overwrite but add to the existing contents.

Ciao,
Holger

Hi, Mukesh

there is a lot of unnecessary movement in the code, and I pretty much doubt that you know what you are putting down as comment should be put down in the code as well:

Please Login or Register  to view this content.

I didn't understand the second suggestion of break point using f9. Please explain it little more for me for better understanding. On which line the break point should be place?

Put the cursor into the first executable line of code and press F9, from my sample this would be the line

Please Login or Register  to view this content.

If the code is fired it will hold on that line and you can step through the rest of the code by pressing F8.

Ciao,
Holger

Hi, Mukesh,

you would neeed to add code lines to empty vTemp as that would hold the value form the array before (sorry I missed that as I didnīt look through the code carefully enough):

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Mukesh

Please Login or Register  to view this content.

adds a blank after each single cellcontent, you might like to check

Please Login or Register  to view this content.

for adding the contents of the cells without a blank.

patience

Who? Me being patient? Not at all ...

Ciao,
Holger