Macro Help for Newbie

P

Phil

I have a spreadsheet with the following headings and
sample data:

FirstName LastName Country Registered

Bob James USA Yes
John Jones Sweden
Paul Burke USA Yes
Bill Spivey USA
Lou Dirks USA

There a over 100 rows similar to the above.
How can I write a macro that goes down the rows and insert
a blank row after every 3 rows?
 
J

Jase

for x = 1 to bottom line + bottom line *1/3 step 3
rows(x).insert shift:=xldown
next x
 
P

Phil

I tried the macro but nothing happened. Also if I don't
join bottom and line as one word I receive an Expected:
End of Statement message.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top