For Loop

[teachMeExcel]

Here i am again with another problem, I am trying to copy a range of cells from 1 worksheet into another, and i am trying to do this in dynamic mode.
here is my coding that obviously doesn't work, I surrounded the code that does not work with >>> <<<<
Legend, Cnt1 points to the current rows and w2_tCol points to the ending column represented in number like column g = 7

Please Login or Register  to view this content.

[martindwilson]

range cells should be in this format

Please Login or Register  to view this content.

so

Please Login or Register  to view this content.

[modytrane]

attach a sample workbook and provide explanation of your needs.

you're supposed to wrap the code as well, don't just type or paste it in the body of the message.

modytrane

[Leith Ross]

Hello teachMeExcel,

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

OR you can also do this manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross