Rick
Fri Mar 14 09:37:34 CDT 2008
Okay, using View Code should have taken you to the right place. Instead of
the code I posted yesterday (which was based on a misunderstanding of what
you were asking), use this code instead... copy/paste it into the window
that comes up when you click View Code:
Private Sub CommandButton1_Click()
Range("A1:AA15").Copy Range("A17")
End Sub
After you turn off Design Mode (on the Visual Basic toolbar), pressing the
button should evoke the above Click event code for the button which, in
turn, should copy A1:AA15 to A17:A31(values and formatting, although none of
the rows or columns in the copy will be hidden).
Rick
"adhide" <adhide@discussions.microsoft.com> wrote in message
news:E2F88025-011F-4858-BDFB-B06CF004C057@microsoft.com...
>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" <adhide@discussions.microsoft.com> wrote in message
>> news:A15C2821-B366-4F3B-86A5-B4BCB5BA33B6@microsoft.com...
>> >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" <adhide@discussions.microsoft.com> wrote in message
>> >> news:6625A646-12CC-41AE-8869-2BA496B47CFE@microsoft.com...
>> >> > 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.?
>> >> >
>> >> >
>> >>
>> >>
>>
>>