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: 1
Default Issue with Hiding Columns


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
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
Hiding Column Issue Amy Excel Worksheet Functions 1 May 19th 09 04:36 PM
Hiding Columns Gord Dibben Excel Discussion (Misc queries) 0 February 25th 09 08:49 PM
hiding columns [email protected] Excel Discussion (Misc queries) 3 July 12th 06 04:42 PM
Hiding Columns Squid[_4_] Excel Programming 4 November 12th 04 01:07 PM
Hiding columns scottwilsonx[_10_] Excel Programming 4 July 26th 04 01:23 PM


All times are GMT +1. The time now is 10:11 PM.

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"