I used the VB toolbar (command button) and then selected the 'view code'
button in the VB tool bar? Then there is where I placed the code?

One other Question, the range I want to copy is A1:AA15 (alot of hidden
cells) and then pase it at A17 and so on?


"Rick Rothstein (MVP - VB)" wrote:

Where did you put the code at? Where did you get the button from (the Forms
or the Visual Basic toolbar)?

Rick


"adhide" wrote in message
...
I get a compile error: Invalid outside proceedure error for 'HIDE' ???



"Rick Rothstein (MVP - VB)" wrote:

Here is the Click event code for a button named CommandButton1...

Private Sub CommandButton1_Click()
Selection.Copy Range("G3")
End Sub

Just change the "G3" to the top left cell reference where you want the
copy
to be placed at.

Rick


"adhide" wrote in message
...
Im wondering if the following is at all possible in excel?

I want to place a button on the worksheet that on enter (press) it
would
duplicate and insert a selected cell range (with formulas) at a set
location
below the selected cell range.?