![]() ![]() All merging conditional formats – xlPasteAllMergingConditionalFormats.This copies and pastes only the column width value from the source cells to the destination cells. ![]() All data and format except the borders of a cell – xlPasteAllExceptBorders.This is all about the theme settings of a cell like bold, italic, font size, etc. ![]() Source theme settings – xlPasteAllUsingSourceTheme.This is the feature in which data in a cell should be selected from a dropdown list of values defined in another sheet/a specific list of hardcoded values. Data validation settings – xlPasteValidation.ConclusionĪs elaborated above, paste special feature can also be used to copy many other parameters of the cells in sheets like: We can note that only the comments have been copied and not the format/values/formulas of the source cells. The same comment can be seen pasted in the same row of col D (the destination range). Range("G5").PasteSpecial Paste:=xlPasteValues Here is a simple piece of code that can do a paste special, copying only the values from cell B5 to G5. Let’s take a look at the code to paste each property one-by-one. ![]() The same “Paste Special” action can be coded using VBA and later used in automation as well. This is the advantage of using “Paste Special.”Īs seen in the “Paste Special” dialog box in one of the images above, the properties in the radio buttons can be chosen one at a time to be copied from a range of cells to another. The colors, size, font face, font style, and other properties have not been pasted. Now we can see that the value has alone been copied from the source cell to the destination cell. I’ll choose only “Values” option and click on “OK” button. The context menu has “Paste Special” option. In this example below, we have copied cell D6 and right clicked after selecting cell G6. This feature is called “Paste Special.”Īfter copying a specific cell, you can try to right click on the destination cell to see “Paste Special” as an option in the context menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |