Hi,

I have used a concatenate function for clubbing two cell values. After clubbing the value is =Sheet1!D2.

I have used paste special as values in 50 Cells in a sheet.

The problem is after paste special, values =Sheet1!D2

I have to press F2 function and press enter to refresh the cell.

Is there any macros which can refresh all the filled cells in a sheet.

Thanx in Advance.

Best Rgds

Akash Maheshwari