View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Getting column width of a hidden column?

Can my VBA code obtain the unhidden width of a hidden column? In order for
my print range to include all of a size-frozen text box, I have to find how
many visible columns cover it. This is no problem, but I have hard coded in
the macro the minimum width needed. I'd rather sum up the widths of A to H
(what the textbox spans if all columns are unhidden) and have the width
base be dynamic.

Don <www.donwiss.com (e-mail link at home page bottom).