Where Do I Post Code

Originally Posted by scotfitz

I'm new to Excel so please excuse a rookie question.

I have the piece of code posted below .... however I don't
know where to place the code.

I am familiar with Access and TradeStation which require
coding, but I don't know where this goes in Excel.

Thanks.

Sub AddRows()
Dim x As Integer, y As Integer
y = Range(Range("A1"), Range("A65536").End(xlUp)).Rows.Count
Range("E1").Select
For x = 1 To y
If ActiveCell.Offset(x - 1, 0) <> ActiveCell.Offset(x, 0) Then
ActiveCell.Cells(x + 1, 0).EntireRow.Insert
x = x + 1: y = y + 1
End If
Next x

End Sub

Hi,

I thought I recognised the code

It goes in the Visual Basic Environment (VBE) which sits 'behind' Excel.

Use the ALT-F11 key to open the VBE
The top left hand window should be headed up Project Explorer or some such - (I use a Mac and the terminology is sometimes slightly different to a Windows PC)

This shows all the various objects such as the workbooks that are open in memory, the sheets which each book contains, and any code Modules or User Forms - which you won't have unless any have been created.

Find your workbook and double click on the 'This Workbook' object. This should open a new large code window on the right. Paste this Procedure in there and you can then close the VBE down - Alt-F11 again.

Now back in the Excel environment you can go to Tools-->Macro-->Macros, find the Macro name 'AddRows' and oduble click it or press the Run button.

Hope this helps,