Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding columns
Hi, thanks for the promt reply. In the report there are a possibility of 19
column headings but depending on the selection criteia the number will vary. All the blank rows will be at the end and I wish to eliminate them to ensure they do not appear in the graph. Davie "Don Guillett" wrote: Do you know which columns. Are they together or at the start/end of the data? -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... hi, I have a spreadsheet with 20 columns but the report which supplies this spreadsheet will supply less than the 20 coumns of information. I want to graph this data but I cannot figure out how to hide the blank columns. Can anyone help? Cheers, Davie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding columns
Don, all the blank columns will be at the end of the range. I want to
eliminate them and then set the graph parameters to the resulting range. Davie "Don Guillett" wrote: Please RE-read my question. -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... Hi, thanks for the promt reply. In the report there are a possibility of 19 column headings but depending on the selection criteia the number will vary. All the blank rows will be at the end and I wish to eliminate them to ensure they do not appear in the graph. Davie "Don Guillett" wrote: Do you know which columns. Are they together or at the start/end of the data? -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... hi, I have a spreadsheet with 20 columns but the report which supplies this spreadsheet will supply less than the 20 coumns of information. I want to graph this data but I cannot figure out how to hide the blank columns. Can anyone help? Cheers, Davie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding columns
something like this should do it for you. Assumes last data has something in row TWO Sub hidecolumns() lc = Cells(2, Columns.Count).End(xlToLeft).Column + 1 'MsgBox lc Range(Cells(1, lc), Cells(1, 20)).EntireColumn.Hidden = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... Don, all the blank columns will be at the end of the range. I want to eliminate them and then set the graph parameters to the resulting range. Davie "Don Guillett" wrote: Please RE-read my question. -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... Hi, thanks for the promt reply. In the report there are a possibility of 19 column headings but depending on the selection criteia the number will vary. All the blank rows will be at the end and I wish to eliminate them to ensure they do not appear in the graph. Davie "Don Guillett" wrote: Do you know which columns. Are they together or at the start/end of the data? -- Don Guillett Microsoft MVP Excel SalesAid Software "davethewelder" wrote in message ... hi, I have a spreadsheet with 20 columns but the report which supplies this spreadsheet will supply less than the 20 coumns of information. I want to graph this data but I cannot figure out how to hide the blank columns. Can anyone help? Cheers, Davie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Programming | |||
Hiding columns | Excel Programming | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Programming |