Results 1 to 3 of 3

Gather 2 macro in one

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    389

    Gather 2 macro in one

    Hello,

    I am using two macros and 2 different button to hide and unhide columns.

    MACRO1:
    Sub HIDE()
        Columns("J:K").Select
        Selection.EntireColumn.HIDDEN = True
        Range("B26").Select
    End Sub
    MACRO2:
    Sub UNHIDE()
    Columns("J:K").Select
        Selection.EntireColumn.HIDDEN = False
        Range("B26").Select
    End Sub
    --> Is it possible to gather those macro and use only one button to hide and unhide the column??

    Many thanks,
    Graig
    Last edited by arlu1201; 07-23-2013 at 10:01 AM. Reason: Changed html tags to code tags.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to gather informations from a form and compile it
    By galegai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2012, 04:42 PM
  2. How to create a macro for analyzing some data that I gather
    By kdrake56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2012, 01:36 PM
  3. Using a template to gather data.
    By d.nguyen09 in forum Excel General
    Replies: 1
    Last Post: 07-19-2011, 02:28 AM
  4. Excel macro to gather data from Fluke 435?
    By chuggins143 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2009, 04:28 PM
  5. Macro to gather data from other workbooks
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-27-2008, 10:42 AM

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