Cells Format change after running a macro

Hi everybody,

I have written a macro that works correctly. but, something weired happens after running the macro. some cells format change automatically after macro run. for example, some cells font become bold some get blue font color.

how can I solve that problem ?

Thanks

Iman

Look for conditional formatting to see if the new values make this happen.

If the macro copies and pastes then you might try to paste values only instead of with formats.