Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting column width of a hidden column?
Hi Don,
One way Dim cWidth As Double Dim i As Long For i = 1 To 8 If Columns(i).Hidden Then Columns(i).Hidden = False cWidth = cWidth + Columns(i).ColumnWidth Columns(i).Hidden = True Else cWidth = cWidth + Columns(i).ColumnWidth End If Next i MsgBox cWidth -- HTH RP (remove nothere from the email address if mailing direct) "Don Wiss" wrote in message ... 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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Column Auto Width and Hidden Rows | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |