| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format columns using a variable name
I would like to format my columns, but I am manipulating my columns by
using variable name (EmptyColumn). Once I copy data in to the colum I would like to format the column to a particular size. Can anyone point me in the right direction for this information? Thanks. Julia |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format columns using a variable name
assuming EmptyColumn is the number of the column,
sheets("Sheet2").columns(EmptyColumn).ColumnWidth = 20 -- Regards, Tom Ogilvy wrote in message ups.com... I would like to format my columns, but I am manipulating my columns by using variable name (EmptyColumn). Once I copy data in to the colum I would like to format the column to a particular size. Can anyone point me in the right direction for this information? Thanks. Julia |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format columns using a variable name
Thanks all for your responses!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Length Columns | Excel Discussion (Misc queries) | |||
| Macros - variable columns | Excel Discussion (Misc queries) | |||
| HLOOKUP using variable columns | Excel Worksheet Functions | |||
| how to sum columns by variable criteria | Excel Discussion (Misc queries) | |||
| search columns, set variable value | Excel Programming | |||
Linear Mode
