Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With your help a while ago I was able to 'vary' the rows being procecessed.
the rows procedure works, I could not get the columns procedure to work. sub variable_rows() ''' this works Dim first, last, hiderange first = 13 last = 15 hiderange = first & ":" & last Rows(hiderange).Hidden = True End Sub Sub variable_columns() '''this does not work, object error Dim first, last, workrange first = 13 last = 15 workrange = first & ":" & last Columns(workrange).ColumnWidth = 20 End Sub Help Please. thanks. -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variable Length Columns | Excel Discussion (Misc queries) | |||
HLOOKUP using variable columns | Excel Worksheet Functions | |||
search columns, set variable value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Is there a Filename property in PrintOut property | Excel Programming |