VBA Simulating a mouse double click

[ReportTeam]

Hi

I am pasting a worksheet which contains formulas into a workbook which contains the same named sheets but the formulas no longer work. When I double click on the cells in question the formulas become operational.

Does anyone have any ideas on how to simulate a double click in a macro?

Thanks

[CCkfm2000]

Hi ReportTeam,

found this link might be useful to you

http://xlvba.3.forumer.com/index.php?showtopic=115

[jfournier]

Did you try setting the cell range's formula equal to itself? I've never done that for getting a formula to work, but I know setting a range's value equal to the range's value gets Excel to re-evaluate the type of data in the cell...

[georgiboy]

Could you post a sheet with the formulae in inactive status?