G
Guest
I am importing .csv files and creating graphs. I recorded macros to do what
I need, but the sheet names that are created automatically also get stored in
the macros. How do I make them generic to any sheet I import? E.g., select
whatever the first sheet is vs. the name that the macro recorded, which will
not be the same sheet name every time. BTW, the macros reformat the first
column, create a graph, then save the graph in a second sheet with. Since
the macros recorded specific ranges during the graphing portion, how do I
modify the macro to select all data in the same columns, not just A1:A75?
I need, but the sheet names that are created automatically also get stored in
the macros. How do I make them generic to any sheet I import? E.g., select
whatever the first sheet is vs. the name that the macro recorded, which will
not be the same sheet name every time. BTW, the macros reformat the first
column, create a graph, then save the graph in a second sheet with. Since
the macros recorded specific ranges during the graphing portion, how do I
modify the macro to select all data in the same columns, not just A1:A75?