Macro/Control object to insert a row

  • Thread starter Thread starter bostontj98
  • Start date Start date
B

bostontj98

I'm adding a macro to a spreadsheet that will insert a row, then copy
the data from the original row. that part works fine, but I can't get
the option button to work in any row but the first
 
Per, sorry for late reply. Wound up doping somehting totally
different, short term. here's the code I had anyway:

Sub InsertRows()
'
' InsertRows Macro
' Macro recorded 9/26/2008 by Antonio Mota
'
' Keyboard Shortcut: Ctrl+e
'
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Rows("275:279").Select
Selection.Copy
Range("A284").Select
Application.CutCopyMode = False
ActiveWindow.SmallScroll Down:=-6
End Sub
 
Back
Top