Akash wrote:

I had a macro which identify the color of the cell and sum the same.

The same was working very fine until I format my Laptop because of
some issue in the HDD.

After formatting the HDD as soon as i am trying to open the same file,
it is stating #NAME?

Can you pls help in resolving the issue.

Not without more information. Post your code.

--
I think my lungs just stuck together from laughing too much!