Hello! I am making a macro that creats a report. The report is presented as a
new worksheet that my macro creates. The input data for the report can be
found in the same workbook as the report. I am basically making alot of
different charts (as well as some tables). In order to keep it flexible for
the user I am not refering dierctly to cells. Instead I use variables to keep
track of where everthing is (the data is identified by the title of the
columns e.g. under the column "Market value" all market values are found
etc.). Now I am making alot of charts. Some of these charts share some basic
setups e.g. gridlines, size, type of chart, types of values on x-axis etc.
However they also differ in many respects e.g. the number lines, the unit of
measurement on the y-axis. If I am forced to have code for all the charts it
is going to be a very long code. I was wondering if there is any convenient
way of utilizing the fact that they share some charachteristics. I am not
very good at neither Excel nor visual basic so I really dont know if it is
possible nor if it desirable. If anyone has any clue regarding this subject I
would be most greatful for your opinions. Thank you all!