View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris100[_65_] chris100[_65_] is offline
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