View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lonnierudd via OfficeKB.com lonnierudd via OfficeKB.com is offline
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