Code to copy any of 50 ActiveColumns from Row9 to Column BE Row9 , Down to Row 2100

[Winon]

Hi to all,

A challenge for you! I cannot get it working. I need code to Look down from the Active Cell Row9 in the Active Column and then have all that info pasted to Column BE Row9 and down as far as it goes.

I am at a point believing it is not possible. But with you clever guys, I would not bet on it as yet.

Any help would be appreciated

Thank you.

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Steffen Thomsen]

This will do

Please Login or Register  to view this content.

[snb]

This will do

Please Login or Register  to view this content.

@Steffen

If you use 'copy' and your range method this would suffice:

Please Login or Register  to view this content.

[Winon]

Thank you snb,

Nice to hear from you again! Are you guys for real? Nice meeting with you as well Steffen. You were absolutely fantastic with your responses. You make it look so simple, maybe because I was taking a for more complicated approach and ended up with the Column Number "113" in Column BF!

I can now take my Pick! It all Works!

You guys ROCK!

Thank you!!!