Hi all, I just want to know that if there is a way to make a VBA that can change normal formula to array formula by: select, edit , press ctrl + shift + enter? (I already wrote all the array formula without pressing ctrl + shift + enter for dragging purpose, now I want to turn those into real array formula). Looking forward to hear from u guys ^^