| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a Column by Number
I have a single cell named range called DateCreated_lbl. I'd like to
apply formatting to the entire column but can't seem to figure out the proper syntax. The following did not work: Range(DateCreated_lbl).Column.ColumnWidth = 16 Columns.Range(DateCreated_lbl).ColumnWidth = 16 Is there a simple way? Thanks - John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference a Column by Number
False Alarm. I figured it out. I was close but not quite there...
Columns(Range("DateCreated_lbl").Column).ColumnWid th = 16 - John John Michl wrote: I have a single cell named range called DateCreated_lbl. I'd like to apply formatting to the entire column but can't seem to figure out the proper syntax. The following did not work: Range(DateCreated_lbl).Column.ColumnWidth = 16 Columns.Range(DateCreated_lbl).ColumnWidth = 16 Is there a simple way? Thanks - John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference a Column by Number
That works but is still only close <g
-- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... False Alarm. I figured it out. I was close but not quite there... Columns(Range("DateCreated_lbl").Column).ColumnWid th = 16 - John John Michl wrote: I have a single cell named range called DateCreated_lbl. I'd like to apply formatting to the entire column but can't seem to figure out the proper syntax. The following did not work: Range(DateCreated_lbl).Column.ColumnWidth = 16 Columns.Range(DateCreated_lbl).ColumnWidth = 16 Is there a simple way? Thanks - John |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference a Column by Number
Assuming if I did Insert=Name=Define, I would see a named range with the
name DateCreated_lbl, then Range("DateCreated_lbl").EntireColumn.ColumnWidth = 16 -- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... I have a single cell named range called DateCreated_lbl. I'd like to apply formatting to the entire column but can't seem to figure out the proper syntax. The following did not work: Range(DateCreated_lbl).Column.ColumnWidth = 16 Columns.Range(DateCreated_lbl).ColumnWidth = 16 Is there a simple way? Thanks - John |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference a Column by Number
Thanks Tom. My version works but yours makes more sense!
- John Tom Ogilvy wrote: Assuming if I did Insert=Name=Define, I would see a named range with the name DateCreated_lbl, then Range("DateCreated_lbl").EntireColumn.ColumnWidth = 16 -- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... I have a single cell named range called DateCreated_lbl. I'd like to apply formatting to the entire column but can't seem to figure out the proper syntax. The following did not work: Range(DateCreated_lbl).Column.ColumnWidth = 16 Columns.Range(DateCreated_lbl).ColumnWidth = 16 Is there a simple way? Thanks - John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate row/column number in reference formula | Excel Worksheet Functions | |||
| Reference a number from a different column in a formula | Excel Worksheet Functions | |||
| Selecting a range using a column number reference | Excel Programming | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
| reference to column (not known) and certain row number | Excel Programming | |||
Hybrid Mode
