Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i clear a perticular range using a function...??? | Excel Discussion (Misc queries) | |||
Function to clear data | Excel Discussion (Misc queries) | |||
Clear Cell If Function = 0 | Excel Worksheet Functions | |||
Help Clear Function | Excel Programming | |||
How Do I Install a Reset or Clear Function | Excel Worksheet Functions |