Results 1 to 12 of 12

Selecting multiple columns with merged cells

Threaded View

maw230 Selecting multiple columns... 08-08-2011, 12:05 PM
Mordred Re: Selecting multiple... 08-08-2011, 12:14 PM
maw230 Re: Selecting multiple... 08-08-2011, 12:23 PM
Mordred Re: Selecting multiple... 08-08-2011, 12:49 PM
maw230 Re: Selecting multiple... 08-08-2011, 12:53 PM
Mordred Re: Selecting multiple... 08-08-2011, 01:04 PM
maw230 Re: Selecting multiple... 08-08-2011, 03:49 PM
Mordred Re: Selecting multiple... 08-08-2011, 03:51 PM
maw230 Re: Selecting multiple... 08-09-2011, 10:36 AM
Mordred Re: Selecting multiple... 08-09-2011, 10:49 AM
maw230 Re: Selecting multiple... 08-09-2011, 10:50 AM
Mordred Re: Selecting multiple... 08-09-2011, 10:58 AM
  1. #1
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Bentley, NM
    MS-Off Ver
    Excel 2010
    Posts
    229

    Selecting multiple columns with merged cells

    I need to write a simple function to hide several separate column sets. I can do this fine manually by selecting the sets (e.g. select Columns D:F -> hold ctrl -> select Columns H:J, etc) and then hiding them that way. However, when I attempt to select these using a macro it will select the entire range that has a merged cell as a title. For example, the range of columns D:L has a title cell called "Margin" that spans the entire range. This seems to be throwing off my macro for selecting separate column ranges.

    How can I fix this?
    Last edited by maw230; 08-09-2011 at 10:59 AM.

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