Copies range without using clipboard. Applies formats into a cell (or range) from another cell.
Can apply from any cell, range, sheet or open workbook into any cell, range, sheet, or open workbook.
Copies range from range to range without using clipboard, Not Copy-and-paste
Instead will duplicate elements one by one for every cell one by one. This is the reason it is taking too long.
Can decide what to copy in the call either CopyValues or CopyFormulas not both
CopyBorders, CopyColWidths, CopyRowHeights
it will always copy font and colors
Returns 0 if not completed, 1 if success.
Used to be called CopyFormat
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
