Programmatically copy data and formatting across worksheets
You can copy data from a range on one sheet to all the other sheets in a workbook by using the FillAcrossSheets method. Specify a range, and whether you want to copy data, formatting, or both.
Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.
Example
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for