List all formulas, defined name on a sheet

[mahmed1]

Hi guys,

Is there a formula or even macro that will list all formulas (plus the cells ranges it refers to) data validations, conditional formatting (and also the ranges it refers to)
defined named ranges (including formula) etc....
On a sheet?

 

[mahmed1]

Hi guys,

Is there a formula or even macro that will list all formulas (plus the cells ranges it refers to) data validations, conditional formatting (and also the ranges it refers to)
defined named ranges (including formula) etc....
On a sheet?

Bump

 

[jasonb75]

Do you have excel jeanie installed? or can you install it?

http://www.excel-jeanie-html.de/index.php?f=1

Setting the options in jeanie to give the required information, then copying the browser preview back to a new sheet is the simplest way I can think of.

 

[mahmed1]

Do you have excel jeanie installed? or can you install it?

http://www.excel-jeanie-html.de/index.php?f=1

Setting the options in jeanie to give the required information, then copying the browser preview back to a new sheet is the simplest way I can think of.

Hi jason,

i dont have the html jeanie installed

would there be a vba code to do this?

 

[jasonb75]

Not that I've seen, and I would imagine to write such code could be quite a hefty task, hence my reason for suggesting something ready made that would do it.

I would assume that as you made no mention as to whether or not you could install the jeanie add-in, that the answer is no.

Will have a look around and see if I can find an alternative.

 

[mahmed1]

Not that I've seen, and I would imagine to write such code could be quite a hefty task, hence my reason for suggesting something ready made that would do it.

I would assume that as you made no mention as to whether or not you could install the jeanie add-in, that the answer is no.

Will have a look around and see if I can find an alternative.

Thank you

IN the mean time i will try to install this jeannie