recurrence: making code work throughout a sheet

EDITED:

I need the below mentioned code in Excel to work within the range of the sheet, so that the copy/paste work within the range of the sheet. C2:C81
As of now, i can only get the compbox to work making copy/paste between the C2 and C3

Private Sub CommandButton2_Click()

If Me.ComboBox1 = Database.Range("C2") And Me.ComboBox2 = Database.Range("C3") Then
Database.Range("A2:C2").Copy
Database.Range("A100:C100").Insert
Database.Range("A3:C3").Copy
Database.Range("A2:C2").PasteSpecial
Database.Range("A100:C100").Copy
Database.Range("A3:C3").PasteSpecial
Database.Range("A100:C100").clear
Database.Range("C2:C81").Sort Key1:=Database.Range("C2"), Order1:=xlAscending, Header:=xlYes



End If
End Sub

I need this code to work throughout the sheet, how do I do that?

Tank you in advance

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new I have done it for you today.)

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code] [/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. I have also done this for you this time.)

Hi Joenne

I am very certain that someone will supply a solution if you attach a sample file and explain step by step what it is you are wanting to achieve...
See Top Yellow Banner regarding file upload...