Hi
for checking if a cell contains a formula you can use
msgbox activecell.hasformula

--
Regards
Frank Kabel
Frankfurt, Germany

"trickdos " schrieb im
Newsbeitrag ...
Hey Guys,

I am interesting in writing a macro to cycle through all the sheets
of
a workbook and see in each cell if it is a formula or if it is a
hardcode. If it is a hardcode, can it create a list on a seperate
sheet of the cell address.

I appreciate any help you can give me.

Thanks,
Brett


---
Message posted from http://www.ExcelForum.com/