You didn't post your code but this idea may help.

if C.HasFormula = False then

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Craig" wrote in message
...
New to VBA....I have set up a workbook that enables me to e-mail certain
worksheets to various recipients...thanks Ron Bruin for the brill
site....various things...1: Is there a macro to protect cells that are
formatted with formula / formatting as when I use my 'Clear' macro it gets
rid of the formula / formatting. 2: Being a novice, when I see code to be
used a lot of the info doesn;t tell me where to put the code. i.e. in a
module, workheet etc...I know the expewrts out there know what they are
talking about but we starters need a heads up, must say though that even
though I am starting up, thank goodness for the discussion groups, it has
help[ed no end...Craig