Results 1 to 3 of 3

Copy VBA function down worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2013
    Posts
    24

    Copy VBA function down worksheet

    Hello,
    I am trying to copy a function down a worksheet and can get all other formatting to copy but cannot get the double-click to hide rows to continue down. This is what I have so far:
    #
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
        If Target.Address(0, 0) = "B3" Then
            Cancel = True
            Rows("4:12").Hidden = Not Rows("4:12").Hidden
        Else
            Cancel = True
            Select Case Target.Interior.ColorIndex
                Case xlNone, 4: Target.Interior.ColorIndex = 3
                Case Else: Target.Interior.ColorIndex = 4
            End Select
        End If
    End Sub
    #

    Thanks in advance for your help!
    Last edited by alansidman; 03-16-2014 at 11:02 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy/paste worksheet function
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2010, 04:16 AM
  2. Is there a function to copy an entire worksheet?
    By nickclingan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-23-2005, 11:23 AM
  3. INDIRECT Function impact on Copy Worksheet
    By BG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. copy worksheet with formulas and vba function
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2005, 05:06 PM
  5. [SOLVED] formula/function to copy from worksheet to worksheet
    By Jen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1