LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Hide non-contiguous cells

I assume this needs to be done using VBA, but I'm willing to do whatever it
takes. I have a rather large spreadsheet and I want to enable the user to
select between 2008 data, 2009 data, or show all. I've done this with a macro
by hiding and unhiding then assigning the macro to the buttons, but when I
click either of the first ones the buttons move to the left edge of the
spreadsheet, and when I open it back up again they're all messed up. The
columns I need to show are non next to each other, so I can't use the
grouping feature (I don't think). Does anybody have an idea of how to proceed?
I'd appreciate the advice and help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Non-contiguous cells Kokomojo Excel Discussion (Misc queries) 2 November 6th 07 04:09 PM
Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column Sam via OfficeKB.com Excel Programming 8 November 5th 07 07:18 PM
counting cells that are 0 in a range of non-contiguous cells Mark Excel Worksheet Functions 9 March 14th 07 02:45 PM
How do I count non-contiguous cells? broush Excel Worksheet Functions 5 May 30th 06 11:16 PM
Hide non-contiguous columns BEEJAY Excel Programming 2 May 23rd 06 01:25 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"