Hi,

First off I want to declare that I'm a complete newbie. I'm usually good at hacking and modifying bits of code to do what I want, but although I've found macros that partially do what I need, I haven't been able to come up with a full function to accomplish what I need.

What I need is:

* Duplicate the current *table* row (where the active cell currently is)
* Have the newly created duplicate be highlighted in yellow
* Have the active cell set somewhere on the newly duplicated row (so that the macro can be repeated as needed--I plan to apply to macro to a button)

What I have so far:

This bit of code will add a row:
Sub AddRow_Click()
  Dim insertBelow As Range
  Dim wks As Worksheet
  Set insertBelow = ActiveCell
  Set wks = insertBelow.Worksheet
  wks.Range("A6").Select
  insertBelow.Offset(1, 0).EntireRow.insert
  insertBelow.EntireRow.Copy
  wks.Paste insertBelow.Offset(1, 0).EntireRow
  Application.CutCopyMode = False   
End Sub
This other bit of code is supposed to highlight (somehow):
ActiveCell.Offset(-1, 0).EntireRow.Interior.ColorIndex = 36
I saw this thread but couldn't get the code to work: http://www.excelforum.com/excel-prog...erted-row.html


If someone can please help me piece together what I need I'd appreciate it immensely.

Thanks!