adding round formula to all cells on worksheet

Hi Folks,

I've had great luck with the members of this site, so here goes...

I have a data sheet where some of the cells are formulas and some are values. This file is submitted each month.

I would like to add the round formula to all the cells in the first 12 columns only, some of which contain current formulas, some which contain hardcoded values. And once this is successful, next month, I will also have cells with the round formula already there.

Therefore, I need a VB macro that will add "=round(....,2)" to cells with values, "round(....,2)" after the 'equals' sign to cells with other formulas, and nothing at all to cells that already have the round formula. Any chance someone could help me out with this? I would be most appreciative.

Thanks.

CCantara

Hi there,

Take a look at the following code and see if it does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M