Delete Specified columns and/or rows script

I have a Jet Report that I created which works great. After the report is created, it auto-hides any column or row that has a jet function in it to make the report easier to read. What i am trying to do is delete any column or row that has HIDE at the beginning. example below-

A B C D E F G
1 hide hide hide hide hide
2 hide
3
4 hide
5
6
7

After the report is saved, Columns ABCEF are hidden, but still there, i don't need this data any longer and would like to remove it from the document without affecting the original excel document.

any suggestions?

You can forget that jet reports was mentioned. Just looking for a way to delete specified columns and/or rows