Save as/Publish Webpage. Filename changes when sheet is deleted and remade

[D13L]

Excel file: Converter.xlsm
Sheet: "Main Chart"

I have a set of charts in sheet "Main Chart" arranged in ("ET1:GD60") and save it as html(This gets me .png image of my charts).

ISSUE: is this number 1121.
This number changes whenever I delete "Main Chart" and remake it again(with identical name).
(note: I get this number by using record macro)

Is there a way to attain this number so it can auto update whenever I delete the sheet and remake it again?
Or is there a another approach that does not utilize this variate number?

Please Login or Register  to view this content.

Any help would be greatly appreciated.