Hi everyone,
I need to write a macro that will run through all worksheets in a given file, creating charts for each of them.
The columns in each of the files/worksheets are always the same, but the number of rows vary. Blank cells are scattered here and there.
I wrote the following VBA script but it fails to work. I would appreciate advice.
I have an extra question as well: I cannot understand why a chart is created in a new sheet and not as an object in the active one?
It is supported by two functions:Please Login or Register to view this content.
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks