problem

[Maciej]

Hello
I'm reading data from text file into excel sheet using VBA. I am
creating (using VBA) chart on 2 imported columns. I want to hide this
columns (Columns("AA").Hidden = True) but it doesn't work - how to
solve this problem using only VBA macro in Excel ?? Pleas help me.

Maciej

 

[John Walkenbach]

That command works on the active sheet. Are you sure the active sheet is
what you think it is?

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

 

[Maciej]

hello John
yes i think so - the problem is: when columns with data series are
visible (i set width = 1 - but they are still visible :-() my chart
looks fine, when I hide this columns (.Hidden = True) my chart looks
like if lost data :-(.
anybody know what to do ??

 

[Jon Peltier]

By default, a chart does not show hidden data. To change this, select
the chart, then go to the Options command on the Tools menu. On the
Chart tab, uncheck the Plot Visible Cells Only box.

- Jon

 

[Maciej]

hi
ok it works manually but I have to generate this file automatically
using VBA macro so how can i set this chart option from VBA code level
??
Maciej

 

[Jon Peltier]

Macie -

I turned on the macro recorder, then did it manually. The recorder gave
me this (plus some other lines not relevant to this option):

With ActiveChart
.PlotVisibleOnly = False
End With

The recorder's good for little hints like this.

- Jon

 

[Maciej]

Thx jon - that's what I want
Maciej

Macie -

I turned on the macro recorder, then did it manually. The recorder gave
me this (plus some other lines not relevant to this option):

With ActiveChart
.PlotVisibleOnly = False
End With

The recorder's good for little hints like this.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______