+ Reply to Thread
Results 1 to 4 of 4

Macro Help - Hiding columns

  1. #1
    Registered User
    Join Date
    10-17-2005
    Posts
    27

    Macro Help - Hiding columns

    This should be the easiest thing ever, but I'm stumped. I created the following macro (via the record feature - not by typing the code) to hide 3 columns in my spreadsheet. When I run the macro, it hides columns B through M for some reason. Help!!

    Sub Hidecolumns()
    '
    ' Hidecolumns Macro
    ' Macro recorded 9/7/2006 by awiebe002
    '

    '
    Range("D:D,I:I,J:J").Select
    Selection.EntireColumn.Hidden = True
    Range("A1").Select
    End Sub

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    I tied out your macro

    It works for me, no problem

  3. #3
    Registered User
    Join Date
    10-17-2005
    Posts
    27

    Now what?

    Anyone have any idea what could be causing this in my spreadsheet?

  4. #4
    Registered User
    Join Date
    10-17-2005
    Posts
    27

    Figured it out

    It was a merged cell that was causing the problem. Fortunately, it wasn't that big of a deal that it be merged, so I just split it back out. Thanks for checking it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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