Hiding columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davethewelder - 18 Mar 2008 18:50 GMT

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 to this Message

Ron de Bruin - 18 Mar 2008 19:24 GMT

Hi davethewelder

Do I understand you correct that you want to hide the columns that are blank with a macro.

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> 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
[quoted text clipped - 4 lines]
>
> Davie

Reply to this Message

Don Guillett - 18 Mar 2008 19:24 GMT

Do you know which columns. Are they together or at the start/end of the
data?

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> hi, I have a spreadsheet with 20 columns but the report which supplies
> this
[quoted text clipped - 5 lines]
>
> Davie

Reply to this Message

davethewelder - 19 Mar 2008 10:14 GMT

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

> Do you know which columns. Are they together or at the start/end of the
> data?
[quoted text clipped - 8 lines]
> >
> > Davie

Reply to this Message

Don Guillett - 19 Mar 2008 15:20 GMT

Please RE-read my question.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi, thanks for the promt reply. In the report there are a possibility of
> 19
[quoted text clipped - 19 lines]
>> >
>> > Davie

Reply to this Message

davethewelder - 20 Mar 2008 10:51 GMT

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

> Please RE-read my question.
>
[quoted text clipped - 21 lines]
> >> >
> >> > Davie

Reply to this Message

Don Guillett - 20 Mar 2008 13:26 GMT

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> 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.
[quoted text clipped - 31 lines]
>> >> >
>> >> > Davie

Reply to this Message