I have been using buttons to insert new rows above them. So the specific inserting action I perform is due to the location of the button.
I need to use a similar method to insert a selection(or copy) from another place in the sheet(that I have hidden). I want to insert that selection of 3 rows and 4 columns above the button that is being pushed. The button is in a different location say...A3.
This is what I use to insert 1 row above the button:
Sub AddRow()
Dim r As Range
Set r = ActiveSheet.Buttons(Application.Caller).TopLeftCell
r.EntireRow.Insert
End Sub
--How do I copy the Range(S12:V14) and place is above the button in A3???
PLEASE HELP!!
I need to use a similar method to insert a selection(or copy) from another place in the sheet(that I have hidden). I want to insert that selection of 3 rows and 4 columns above the button that is being pushed. The button is in a different location say...A3.
This is what I use to insert 1 row above the button:
Sub AddRow()
Dim r As Range
Set r = ActiveSheet.Buttons(Application.Caller).TopLeftCell
r.EntireRow.Insert
End Sub
--How do I copy the Range(S12:V14) and place is above the button in A3???
PLEASE HELP!!