Hi guys,
I need to write a very simple macro in VBA, so I hope someone will be willing to use a couple of minutes to help me with that.
I just need to copy values from one range in Sheet1 into another range in Sheet3, but i must have 12 empty rows under every row from the original range. In this 12 rows I need to paste another range, filled with formulas.
I will try to be more specific by giving an example. I have three ranges:
So I need to copy the values from the first row in Range1 and paste them into the first row in Range3. Then I want to copy the formulas in Range2 and paste them into the next 12 rows of Range3. So I copy row 2 from Range1 and paste it into row 14 in Range3. Then again i paste Range2 into the next 12 rows of Range3, and so on.
I hope that this description was understandable. The macro should be very easy to write, I think, but I know almost nothing of VBA. I could write this program myself using a simple For Loop statement, but the problem is that it seems to be much harder to work with ranges, than with two-dimensional arrays. VBA does not seem to accept ranges of the type Range("Ai:BHBk"), where i and k are long variables...
Anyway, thenks for the help!
Bookmarks