I have data in sheet1 with full of formulas. I want a VB/Macro program to save result in another sheet in selected cells. I want to save results, not the formula. for example: I am having data in cell B5 as "=A1" and data in cell C5 as "=A2". When i try to save cell B5 & C5 in another sheet by a macro, it copies "REF!!" or error but if i copy data of cell A1, it copies perfectly. Doesnt it copies formulas? Someone help me how can i do this.