LinkBack URL
About LinkBacks
How do you copy a worksheet exactly as it appears (ie: cell sizes, etc the same). Thanks, Randy
How do you copy a worksheet exactly as it appears (ie: cell sizes, etc the same). Thanks, Randy
Maybe...
Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Select the source worksheet by clicking on the triangle just above the row numbers and to the left of the column letters. This will select the whole worksheet. Click Copy. Go to the destination worksheet and select A1 then click on the Paste button to expand the choices (arrow on the button) and choose, Keep Source Formatting. All cell, and font formatting as well as formulas with their results will be pasted, making an identical worksheet.
If the copy is to be in another workbook, open the destination workbook, right click on the tab of the worksheet to be copied and choose Move or Copy. Select the workbook just opened, select the location for the copy, select the checkbox for copy and click OK. An identical worksheet will be created in the destination.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks