Re: $$Excel-Macros$$ How to Clear the Cells

Dear Karthik, Include following lines in your code when you have selected the respective region. Selection.SpecialCells(xlCellTypeConstants, 23).Select Selection.ClearContents Check the attached file for more understanding. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA M

$$Excel-Macros$$ How to Clear the Cells

Hi all am new to this grp.. Happy New Year. Query: in macros how it can be programmed to clear the cells , except cells containing formulae or links etc(means cells having "=...) please help me -- -- So