Inserting Rows Between Rows With Data

Solon Aquila

New Member
Joined
Sep 24, 2011
Messages
33
My apologies for this post, but apparently I can't even figure out how to apply information that's already in the forums.

I receive worksheets with two columns of data: Degrees and Distance
(How far something is away at each degree of rotation)

I need to interpolate the data down to half, quarter, and eighth degree increments.

I manually add rows between each degree the copy/paste the .125, .250, .375 etc into each cell in the Degrees column.

I manually enter the formulas between the data in the Distance column (copy/paste after the first batch).

It works fine, but increasing 360 entries to 2800 entries is a LOT of copy-paste.

I tried starting easy: select active cells in a column (macro version of Ctrl+Shift+Down) on the idea that I don't want to insert rows between ALL the rows in the spreadsheet, just however many degrees of data we've been given. I failed even selecting active rows.

Here's my 'step 1' that failed:
(Got it from http://www.mrexcel.com/forum/showpost.php?p=2864532&postcount=3).


Sub InsertRowsBetween()
Range(Range("A1"), Range("A1").End(xlDown)).Select
End Sub


Any ideas what I missed would be appreciated and, if possible, a note about what each step does: I want to learn how to create, not just copy other people's posts.

Thank you,

Solon
PS - and how do I post a link to a thread, not just a post? My brain must really be ailing today!
 
Solon Aquila,

Thanks for the feedback.

You are very welcome. Glad I could help.

Come back anytime.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top