F9 keystroke

[AmyTaylor]

Hi I am very new to visual basic and wondered if anyone knows how I can get Excel to do the recalculate F9 keystroke ? I dont want the user to be able to automatically recalculate but in some instances I want Excel to automatically calculate the cells and think programming the F9 keystroke might work.

Thanks
Amy
xx

[rvExcelNewTip]

I'm not sure what ou want to accomplish, but the Calculate method can be used to perform the calculation when you need it. Calculate can be applied at the Workbook, the Worksheet or a specified Cell Range level e.g.

Application.Calculate
Worksheets("Sheet2").Calculate
ActiveShet.Range($A$1:$B$10).Calculate

[AmyTaylor]

Hey, thank you for replying, will give it a go and get back to you if it doesnt work!


Amy
xx