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
 
Hi

Post your code, so we can se what your have got so far.

Regards,
Per
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get Name of Sheet to use in Macro 11
Macro to insert a line when a value changes in a range 1
Inserting a Copied Row inside a table 6
Copying Row Code Doesn't Copy Conditional Formating 10
Using Drop Down Menu for Macro 6
insert a line 1
insert rows automatically 7
go to first cell of inserted row 2

Back
Top