Copy Data from one sheet to another.

[microwaveeng]

Hi all,

I want to write a vbscript that does the following:

- Insert a empty row after every 4 rows of data.

Basically, I do not know how to start...I am having trouble figuring out how to tell excel to keep adding a blank row after every 4 rows of data until the end of the data.

Thank you.

 

[xlbo]

1st - find the end of your data - there are 2 FAQs in this forum about that

Then, use a loop to loop through the rows from the bottom up - have a look at "loops" in VBA help files

Record yourself insserting a row and then use that code within your loop

Post back with what you have tried if you cannot get it to work

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question