Insert row that copies formulas and formats from another row

**jas001** · 11-26-2012, 06:40 PM

I am very new to macros but i am trying to record a macro that will copy a specific row (row 500) and insert copied row into my current selected row or rows. When I record it, it makes the insert area static and always in the same spot. I want it to put it into the row i have selected when i hit my macro short cut. Any help is appreciated.

Current Macro:
Sub InsertRow()
Rows("500:500").Select
Selection.Copy
Rows("52:52").Select
Selection.Insert Shift:=xlDown
End Sub

I want the Rows("52:52") to my current selected row instead of always 52.

**haripopuri** · 11-27-2012, 01:14 AM

Please keep code in code tags.

Try this.

Please Login or Register  to view this content.

**jas001** · 11-27-2012, 12:09 PM

Awesome! That worked. Thank you so much. I am a rookie so how do I keep the code in code tags for future reference?

**haripopuri** · 11-27-2012, 01:06 PM

If the reply worked for you, please update the status of thread as [solved]

-------------
If my answer helped, you can click on the star and add to my reputation.