Excel Visual Basic Macro Help...

Discussion in 'Trading Software' started by ang_99, Dec 19, 2005.

  1. I want to add spaces say every 10 rows for about 15,000 rows.

    I'm guessing you can create some type of macro to do that but I'm not sure how I would go about doing that..

    I recorded a little test macro that looks like this...

    Sub Space()
    ' Space Macro
    ' Macro recorded 12/19/2005 by A
    ' Keyboard Shortcut: Ctrl+Shift+S
    End Sub

    Is there some type of formula I can use in that first "Range" line instead of A10,A20,A30, etc...for ex. (A10+10*15000) or something to that effect. (that doesnt work btw)

    Or is there a better way to insert 1500 rows ever 10th row :confused:
  2. skepticaltrader

    skepticaltrader Guest

    PM "ElectricSavant" on here. He is the Excel Guru on ET.