Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi all, I'm having an issue with hiding columns. I have a worksheet with a statement summary at the top and on row 20 filters to select customer invoices. Now, i set a macro to hide rows 1-19 and certain columns - say B, D, & F. Hiding manually by highlightling and selecting hide works, but when i replay back the macro it hides columns A-C, for example. I have no idea why it does this and i experimented with using column widths at 0 instead, but with the same result. I would post the code, but i don't have it right now (it's v.simple). In the meantime if anyone has come across this problem before and knows how to solve it i would be very very happy. Thanks as always, Chris -- chris100 ------------------------------------------------------------------------ chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166 View this thread: http://www.excelforum.com/showthread...hreadid=536574 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding Column Issue | Excel Worksheet Functions | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
hiding columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Programming | |||
Hiding columns | Excel Programming |