Wednesday, January 26, 2011

Excel VBA: Ignore Merged Cell Warning

Excel can be annoying sometimes. Take for example the stupid alert letting me know I'm trying to do something with a merged cell. Sometimes this sort of thing is good to know but more often than not, I know what I'm doing and want to do it without being nagged about it. So, for future reference, if you want to suppress the merged cell alert just enter this VBA code in your workbook:
Application.DisplayAlerts = False

No comments: