Hello everybody.
I'm working on a macro to automize the creation of a graph. The creation of the graph is no problem.
But now I want to clean up the graph, I want to delete the columns that have no data for the graph in it.
In the range of the X-axis value are merged cells
As the position of the empty columns can change I cannot use the code like
Columns("O:O").Select
I use the code
Columns(legekolom).Select
where 'legekolom' is a reference number for the involved column
With this code not only the referenced column is selected but all the columns that are part of the merged area where the column goes through.
Attached you can find the module of the clean up phase.
Any help is appreciated
Luc