PasteCell.PasteSpecial xlPasteValuesAndNumberFormats 'command to pasted cells to keep the source formatting Set PasteCell = Application.InputBox('Paste to any blank cell:', xTitleId, Type:=8)

'Set a Input Box to take a range to paste to Set Cop圜ell = Application.InputBox('Select Range to Copy :', xTitleId, Cop圜ell.Address, Type:=8) 'Set a Input Box to take a range to copy from 'Set copy range will be selected from the worksheet 'declare Cop圜ell and PasteCell as range variableĭim Cop圜ell As Range, PasteCell As Range

Then, click on the Insert, choose the Module option.

Firstly, press Alt + F11 to start a Macro.

We’ll use the box to select a range and then paste it into another cell. Add Input Box by Using VBA PasteSpecial and Keep Source Formatting in Excelįirst and foremost. Here is a sample data set that we will use to copy and paste.ġ.

We’ll demonstrate four examples of how to use the paste special in VBAwhile retaining the source format in the sections below. To make this the default setting, open Microsoft Word and go to File > Options.4 Easy Examples to Apply VBA PasteSpecial and Keep Source Formatting in Excel Paste Plain Text Only without the formatting in Word However, if you often paste text from another program and you never want to keep the formatting, you can set Keep Text Only as the default setting. It works perfectly when you need to do that once or twice. You can paste the text into Word and make use of the Paste Options to remove the format and keep the default text as you have set in Microsoft Word.

However, you do not need such formatting in Microsoft Word.

The text in Google Chrome has a BOLD and ITALIC format. Let’s assume that you need to paste some text from Google Chrome to Microsoft Word. If you want to paste it as Text Only without the formatting, here is what you have to do. When you paste text having a different format than your default Microsoft Word’s format, it keeps the source program’s format. For example, you often paste text from other programs such as browser like Google Chrome or Mozilla Firefox. However, some people need different options to do different things. Microsoft Word is probably the best tool for writers.

Source formatting in word