copy one column to another active x

[super_saiyans]

is anyone familiar with active X?

i am ttrying to copy 1 column from excel file to another. 

it was sucessful for the 1st column, 

but not the N columns?

i think my FOR LOOP is correct!

i also dont get errors but i dont get the results

[super_saiyans · Accepted solution]

[ben64]

The problem is that you are initializing the shift register with the range of all columns but at the right end of your FOR loop you are passing the destination column range to the shift register. You should pass the range of all columns reference back to the shift register. You should close both column range references in the FOR loop and the range of all column after the FOR loop when no longer required.

Ben64

EDIT: seem you've found your own solution.

[super_saiyans]

thanks for the advice!

lol. i have been working on it for a week.

i tried everything.

stacked sequences worked but it was too much work.

THANK YOU again