Hi,
I have been using excel on and off for a long time and because I chop sheets from 1 work book to another, I have ended up with the following problem.
I have work books in which the units used from sheet to sheet vary.
The width of a column on one sheet may be in inches whilst in the sheet after the column widths are in a decimal format.
Is there any way to change the work book so all sheets use the same units for all sheets?
Many thanks
You can copy and paste ... or you can copy and paste: values & formats
I can't vouch for this tool but it seems like a winner: https://www.excelcampus.com/tools/format-copier/
Sub PasteSpecial_Examples() 'Use the Range.PasteSpecial method for other paste types 'Copy and PasteSpecial a Range Range("A1").Copy Range("A3").PasteSpecial Paste:=xlPasteFormats 'Copy and PasteSpecial a between worksheets Worksheets("Sheet1").Range("A2").Copy Worksheets("Sheet2").Range("A2").PasteSpecial Paste:=xlPasteFormulas 'Copy and PasteSpecial between workbooks Workbooks("Book1.xlsx").Worksheets("Sheet1").Range("A1").Copy Workbooks("Book2.xlsx").Worksheets("Sheet1").Range("A1").PasteSpecial Paste:=xlPasteFormats 'Disable marching ants around copied range Application.CutCopyMode = False End Sub
Last edited by Logit; 12-15-2016 at 09:11 PM.
Thankyou very much, I will give it a go.
Your welcome.
Merry Christmas !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks