Start filling data in a range after completing another??

Zhennie · 10-21-2009, 09:50 AM

Here is part of a macro I wrote, it works, but it seems to me a dull way to do it... Is there a better way to make it complete row 4 up to column 14 and then continue to row 8 - again up to column 14?

Please Login or Register  to view this content.

**shg** · 10-21-2009, 09:59 AM

Welcome to the forum.

Please take a few minutes to read the forum rule, and then edit your post to amend the thread title and add code tags.

Thanks.

Zhennie · 10-23-2009, 01:46 AM

Any ideas???

**shg** · 10-23-2009, 10:23 AM

Maybe if you'd tell us what you're trying to do?

Zhennie · 10-26-2009, 03:16 AM

I want it to complete a table, with data entered through a userform. It completes rows. What I want it to do is to start completing A4, let's say, with the data entered, but when it reaches N4 I want it to move to A8 - and start filling that row, again up to N8... Did I make it clearer?

The solution I came up with seems to me too heavy...