I was having a problem to a PasteSpecial (format only) for a few hundred
rows. I finally broke it up into smaller chunks, paste n rows at a time.
Currently doing it in two rows chunks works, but takes a long time.

Is there some way to determine, other than a binary search on chunk size,
how many rows can be pasted at a time. Note: cells involved have
conditional formatting and table formatting

Note: Excel automation project in C#