ExcelBanter - Limitations of Excel PasteSpecialFormat

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Limitations of Excel PasteSpecialFormat (https://www.excelbanter.com/excel-discussion-misc-queries/180962-limitations-excel-pastespecialformat.html)

Desmond Cholerton

Limitations of Excel PasteSpecialFormat

Does any one know what defines the limits of this function when copying the
format of three adjacent cells to a large selection of cells (eg 100 rows by
66 columns) in one worksheet. I get an error message "Selection is too
large"
Thanks
DBH

All times are GMT +1. The time now is 09:09 PM.