getting rid of warning sign 1

[Blyss]

I am running a macros that somwhere along the lines merges some cells together. When i run it, a warning pops up telling me that the cells i'm merging will only display data in the cell in the top left-hand corner. It comes up mulitple times because i'm merging multiple groups of cells.
I just want to stop these messsages from popping up everytime i run the macros and stop the damn computer from beeping so much. Is there a way?

Thanks

 

[BrainB]

Try Application.DisplayAlerts =False
Don't forget to reset to True at the end.


Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[Blyss]

Yes thank you...just what i needed.