Try the Application.CalculateFull method

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Argent" wrote in message ...
| This is one that's bugged me for years. The latest example is: I have a
| macro which pastes a column of numbers into my worksheet (target cells can be
| general or number it makes no difference) . Programmatically, I apply
| conditional formatting to the pasted cells. Most of the time this works but
| sometimes, the conditional formatting does not display until I hit F2 on each
| cell in turn once the macro has finished. This is not acceptable as this
| macro is part of a large Office application and runs automatically. My users
| won't take kindly to having to fiddle with the spreadsheet. I do not want to
| change the values in my cells, just have Excel format them properly. Surely,
| there's a way - other than copy-paste multiplied by 0 - to get this to work?
|