H
hans.joachim.klotz
Sorry, maybe it is a stupid question.
I will (must) learn VBA step by step.
I have a book about VBA but it's very big ;-(
I will create some diagramm from data files with a lot of columns and
rows.
The end of rows not the same in every file
The structure of every file is the same.
I have a header from A1 to B10
The values stored in a range from A11 to T nnnn
nnnn can be 1235 or 2344 or 4500 and so on
The structure of the values are:
X Y1 Y2 Y3 Y4 ... Y9 Y10 Y11 Y12 ... Y16 Y17
I need for example some diagrams with X until Y4 or X+Y10 or X+Y16+Y17
If I would use the command
all cells would selected and I must delete the not neccessary datalines
in the diagrams
Better there is a command in the type
Column X+column Y1 to column Y4 or
Column X+column Y10 or
Column X+column Y16+Y17
I hope I have decribe my problem and someone can give me an idea in
wich way I must solve my simple ;-) problem
Thanks a lot
Jochen (.de)
I will (must) learn VBA step by step.
I have a book about VBA but it's very big ;-(
I will create some diagramm from data files with a lot of columns and
rows.
The end of rows not the same in every file
The structure of every file is the same.
I have a header from A1 to B10
The values stored in a range from A11 to T nnnn
nnnn can be 1235 or 2344 or 4500 and so on
The structure of the values are:
X Y1 Y2 Y3 Y4 ... Y9 Y10 Y11 Y12 ... Y16 Y17
I need for example some diagrams with X until Y4 or X+Y10 or X+Y16+Y17
If I would use the command
all cells would selected and I must delete the not neccessary datalines
in the diagrams
Better there is a command in the type
Column X+column Y1 to column Y4 or
Column X+column Y10 or
Column X+column Y16+Y17
I hope I have decribe my problem and someone can give me an idea in
wich way I must solve my simple ;-) problem
Thanks a lot
Jochen (.de)