Macro to set an html anchor?

[Kevin]

Is there a way to have a vba macro to set an html anchor point at a certain
cell?

I can add one manually by going into microsoft script editor.

I save the workbookas a .htm file so all of the html needed is saved in the
FileName_files directory, in those you can add anchor points but I would like
to do it automatically as the macros fill in the spreadsheet.

Any help is appreciated.
Is there maybe another forum that talks about the html part of excel??

Thanks,
Kevin